Microsoft Access Parameter Query
Asking the user for criteria when you run your queries
Q: I would like my users to be able to change the
criteria for a query, but not have to learn how to make design changes.
For example, when I run a query of customers by state, I want the user
just to be able to type in the state when the query runs - perhaps with
a prompt. Any ideas?
A: To do this, use an
Parameter Query. To do this, just place a criteria for the field(s)
you want to have parameters for, and put a prompt for your user inside
of square brackets. Like this:
Now when your query runs, you'll be prompted to enter the state as a
Here is a FREE VIDEO TUTORIAL
that will walk you through this topic in detail.
I teach the concepts in this free mini tutorial in my
Access 102 course. These are
full courses - over 60 minutes in length each. I spend a lot more time going
over how to do this, in addition to lots more tips and tricks.
UPDATE: I also cover
Parameter Queries in a lot more detail in
Access 2010 Beginner Level 5.
By Richard Rost
Click here to sign up for more FREE tips