prompting query

  • Thread starter Thread starter Olga
  • Start date Start date
What criteria do you need? Without a specific question, I can't give you a
specific answer.

If you want to evaluate a "DateAdded" field, for example, in the "Criteria:"
field under the DateAdded column, enter:

=[EnterDate]


If you want to see all items added between two dates, enter something like:

Between [EnterStartDate] and [EnterEndDate]


If you want to see all the items for a particular state, you would need to
have a state field in the query and then uder it put:

[Enter State To Include]




The items in brackets[] are what the user will see. You can put anything
you like in the brackets.

Rick B




Hi,

How can I get a query to prompt me for the criteria

Thanks
Olga
 
Back
Top