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.
 
Back
Top