Execute a query

G

Gregg de Boisblanc

We have recently converted a database from Lotus Approach to MS Access. We
are trying to create queries in order to search 6/7 fields. We see that we
can create queries using the wizard, but cannot figure out how to execute the
query. Based on what the built in help suggests, we are to click on the "!"
button however, it is not displayed and we cannot seem to be able to add it
to the tool bar.
Please help!
 
J

John Vinson

On Mon, 27 Jun 2005 16:59:02 -0700, Gregg de Boisblanc <Gregg de
We
are trying to create queries in order to search 6/7 fields. We see that we
can create queries using the wizard, but cannot figure out how to execute the
query.
Click to expand...

You don't need to "execute" a search query (an Action query, such as
an Append query to add new records or an Update query to change
existing ones, is a different story).

A search query can be opened by doubleclicking, or (better) you can
base a Form on the query (just as you would base a form on a table) to
display data onscreen; or base a Report on the same query, for
printing.

John W. Vinson[MVP]
 
Top