Paramer queries

[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

 

[Steve Schapel]

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.

 

[M.L. Sco Scofield]

Take a look at
http://support.microsoft.com/default.aspx?scid=kb;en-us;210530. I've used
this technique before. It might do what you want.

Good luck.

Sco