user prompts

  • Thread starter Thread starter Lauren B.
  • Start date Start date
L

Lauren B.

How can I write a query so that the user receives two prompts-- one asking
for a start date and one asking for an end date?

Thank you
 
Lauren

If you enter something within []s in the Criteria row of the query
design grid, the user will be prompted accordingly, and whatever they
enter in response to the prompt will be used as a selection criteria on
that column. This is called a Parameter Query. If you mean that the
start date and end date criteria will be applied to the same field in
the query, maybe you need something like this...
Between [Start date...] And [End date...]
 
Back
Top