How to use a field on a form with a query.

[frontside]

I´m doing a report which the query gets a value from a field in a form. there is no problem using one value for example, if I type a number ex 350 in the field the query/report will show only the records with the number 350!
the problems comes when I want to choose more than one number for example, I would want both 350 and 700 to show in the report.
With my knowledge I thought that would be an easy task by just writing 350 AND 700 in the field (since the query gets the value from the field that should work, right?)
But no...

My question is, how do I use a field in a form for choosing more than one criteria. The best way would be to write 350,700 or 350;700... I know I could show the customer

Would really appreciate any suggestions.

Micke "Sweden

 

[SteveR77]

Micke,

You could use a single field as you are doing and have the string parsed base on the delimiter that you have selected.

Take a look at the following link. I believe it will be what you need.

http://www.mvps.org/access/strings/str0003.htm

Cheers,


Steve

PS - Also I know the PHV and others have posted FAQs and sample code concerning how to do this as well.