Select queries (as opposed to Action Queries) are used to retrieve data from tables and other queries. Select queries do not modify the databases data in any way; they simply produce a temporary recordset of data determined by the criteria specified in the query.
Select Field1, Field2, Fieldn From Tablename
Select queries usually include optional clauses to specify the criteria for records to be selected and the order in which selected records are to appear. The SELECT article describes these clauses.
|This page has been accessed 313 times. This page was last modified 15:40, 21 April 2012 by Glenn Lloyd. Disclaimers|