Parameter Query

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

I set up a paramter query where I enter a number in and hit ok and then it
pulls up a report with information relative to that number. How do I make it
so I can enter multiple numbers and pull them all up in one report?
 
but the numbers are random based on entry in a form seperated by a comma -
and they have . in the as well
 
Andrew said:
but the numbers are random based on entry in a form seperated by a comma -
and they have . in the as well
Click to expand...
Andrew,
You cannot use the In() statement directly if you are entering the data
from a form. Access will treat a string of "1","5",",9" as one string,
not as 3 separate strings, so it looks for "1,5,9", not 1 then 5 then 9.

See Microsoft KnowledgeBase article:

100131 'How to create a parameter In() statement'
or..
210530 (Same as above for Access 2000)

for a method to use a form to enter multiple In() criteria.
 
Back
Top