I have Access 2002 and I can't seem to get a "Create View" SQL st.

[LoveLee]

I am trying to use the CREATE VIEW statement in SQL for Access 2002.
Here is what I am trying to RUN:

CREATE VIEW Spr02St AS SELECT stID, gTerm FROM Student, Grade WHERE
gTerm="Spring 2002" and gstid=stid GROUP BY stID, gTerm SELECT Count(*) AS
[Spr02 Student Total] FROM Spr02St;

When I press the RUN button I get this error message: "Syntax error in
Create Table statement"

Help!

 

[John Vinson]

I am trying to use the CREATE VIEW statement in SQL for Access 2002.

Access - using the JET engine and the default DAO object model - does
not support Views. The equivalent of a View in (default) Access is a
Query; a Select query looks, acts, and feels very much like a
SQL/Server View with the advantage that (in many cases) it's
updateable with no code.

Try creating a Query based on your table and see if it meets your
needs.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Duane Hookom]

Access doesn't support CREATE VIEW unless you are working in an ADP. Also,
Access MDBs would not support two separate SQL statements in the same query.