J John Vinson Dec 11, 2004 #2 Exaclty what are views and how can you create one? Click to expand... Views are the SQL/Server or Oracle analogs of Queries. You create one using a pass-through query like CREATE VIEW SeniorEmployees AS SELECT EmployeeID, LastName, FirstName, Grade FROM Employees WHERE Grade > 5; You can then refer to SeniorEmployees as if it were a table. Views are not commonly used in Access, however; they're not supported by the JET database engine. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps
Exaclty what are views and how can you create one? Click to expand... Views are the SQL/Server or Oracle analogs of Queries. You create one using a pass-through query like CREATE VIEW SeniorEmployees AS SELECT EmployeeID, LastName, FirstName, Grade FROM Employees WHERE Grade > 5; You can then refer to SeniorEmployees as if it were a table. Views are not commonly used in Access, however; they're not supported by the JET database engine. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps
