Kate said:
Where does a SELECT Statement get placed? Is it in a query in a
criteria or field expression? Can you give me a detailed example
please? Thank you. --
kate
Create a query in Design view or using the wizard if you have to. Once
the query is constructed, switch the query to SQL View using the View
menu, or the toolbar button, or the right-click context menu. There you
will see the SELECT statement (if you have created a SELECT query, that
is - there are other types of queries in which the word "select" never
appears - action queries such as update, insert and delete queries). So,
at a bird's-eye view, a query that selects records is a SELECT
statement. In realit, what you see in the Design view is the interface
that Access uses to allow users to build a query. The goal is the
generation of the sql statement which the database engine can understand
and run. You do not have to use the interface: you can create a new
query in Design view without using the wizard and immediately switch to
SQL View where you can type a select statement directly.