J
John Vinson
On Mon, 10 Jul 2006 13:19:02 -0700, mwest
It's considered polite to use the big white textbox for your question,
not just the subject line.
To query two fields (or sixty-four fields for that matter), create a
new Query based on the table. Put as many criteria as you need on the
Criteria line in the query design window. Open the query by clicking
the datasheet icon on the left of the toolbar; or save the query and
simply open it by doubleclicking it in the Queries window, or (better)
base a Form on it and display the data by opening that Form.
John W. Vinson[MVP]
It's considered polite to use the big white textbox for your question,
not just the subject line.
To query two fields (or sixty-four fields for that matter), create a
new Query based on the table. Put as many criteria as you need on the
Criteria line in the query design window. Open the query by clicking
the datasheet icon on the left of the toolbar; or save the query and
simply open it by doubleclicking it in the Queries window, or (better)
base a Form on it and display the data by opening that Form.
John W. Vinson[MVP]