need help regarding creating views

[cardinal]

hi,
i am actually trying to create a view using the following syntax


CREATE VIEW Pa_only (name, number, st) AS
SELECT student_name, student#, state
FROM Students
WHERE state = ‘PA’;
but i am getting an error
saying syntax error in create table statement

plz help me out

 

[sfreeman@co.mer]

There are no 'Views' in Access. You can take a look at creating a query.

I think when you run your code, Access thinks you are trying to create a table, and doesn't like the syntax.