ms-access-course - criteria in queries

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » ms-access-course - Criteria In Queries

ms-access-course - Criteria In Queries

resolvedResolved · Low Priority · Version Standard

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.


 

Access tip:

Undo Entries In Records

To Undo any entries or changes in records:

Hit the ESC key once for the current field

And ESC twice for current record

View all Access hints and tips


Server loaded in 0.08 secs.