tina has attended:
Access Introduction course
Criteria In Queries
How do I set changeable criteria in queries?
RE: Criteria In Queries
If you use square brackets in the criteria field
eg. [criteria here]
then access will prompt you to enter the value when the query is run.