Parameter query question

  • Thread starter Thread starter Joe D
  • Start date Start date
J

Joe D

Is there a way to run a parameter query that will allow the user to
input multple selections. For example, I have a query for Sales by
SalesRep. The table contains over 100 sales reps numbers. How can I
get the user to get a list of only five of these numbers. The numbers
will vary according to the user. I realize I can put the numbers in
the criteria of the query, but that would not be helpful to the user.
If I put a parameter in the criteria that says [Enter Sales Rep
Number] it only allow 1 number to be entered by the user. Any
suggestions?
 
One simple method is to have a table of Sales Rep Numbers with a second
Yes/No fieldnamed [Include]. You can then allow users to "check" the include
field for the sales reps they want to include in the report. Add the table
to the report's record source and join the SalesRepNum fields. Add a
criteria for [Include] = True.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Data in One Table from Another Table 2
Parameter Query 1
Code Check Request - Query to find reused values 2
Parameter in Crosstab Query 4
Parameter Query Won't Run 0
Cross Join - Please Help! 5
Creating an audit trail of changes 1
Parameter Value in Crosstab Query 4

Back
Top