Jeff Greenlee
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by Jeff Greenlee
-
-
Hi, I'm new to this forum.. I was checking out the little tutorial here on SQL.. I used to use it all the time 4 years ago, but I'm a little rusty so I'm oiling the joints so to speak.. (says tinman!) Anyway, the end of the advanced section mentions creating views in the Northwind database. So I opened up Nortwind in my trusty Access and tried running the SQL query: CREATE VIEW [Current Product List] ASSELECT ProductID,ProductNameFROM ProductsWHERE Discontinued=NoSeems simple enough.. but I get an error: "Syntax error in CREATE TABLE statement." does Access allow you to create views? Or am I jest a little too far behind the eight ball?Jeff
Creating Views in Access?
in SQL
Posted