Parameter Query

  • Thread starter Thread starter jon
  • Start date Start date
J

jon

I currently run a parameter query on the following 3
fields: Position, Date, Value. Each field has the
parameter details in the criteria

I therefore have 3 sets of prompts coming up. Is this the
best way to run a query that asks for variables? or is
there a better method.

The position fields have admin, sales, clerk and Manager.
I would like if possible for the Position field to ask for
any number of variables (ie clerk, admin, sales or
Manager, sales etc)

I feel my method is somewhat laborious for the end user.

Any suggestions would be appreciated?
 
Jon

First, if you actually have fields named "Date" and "Value", consider
renaming them. These are reserved words in Access and you will only cause
both yourself and Access headaches by using them.

A typical approach when there are multiple parameters is to create a form to
"collect" the parameters, then base the query on the values in the form.
This will also allow you to use combo boxes on the form to limit the values
that might be selected.
 
Back
Top