Exaclty what are views and how can you create one?
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
