I searched some of the previous posting regrading a 'Create View',
it provided a syntax along with MS explanation of a Creat view.

I opened a Data Definition Query and entered the following

CREATE VIEW testview AS SELECT* FROM tbl_Diagnosis

When I go to run it, I get "Syntax Error in Create Table" statment and then it
highlights to the VIEW

My syntax seems correct and I event substituted the * with the field names but the same error.