Paramer queries

  • Thread starter Thread starter Mike Marquardt
  • Start date Start date
M

Mike Marquardt

I have several parameter queries that I want to be able to
put multiple values. The pararmter I am using is in([enter
store number]) but if I enter 1234,4564,1256 I do not get
any results. I know I need to set this up as a string but I
have not had any sucess. Any ideas?
Thanks
 
Mike,

This approach can't work. Anything you enter in response to a parameter
prompt can only ever be interpreted as a single value, Access has no way
of knowing that putting ,s in there means more than one value. One way
to do this would be to use a criteria expression like...
[enter 1st store number] Or [enter 2nd store number] or [enter 3rd store
number]
.... but obviously this is unsatisfactory if you want the number of
choices to vary.
 
Back
Top