Parameter Query - Multiple Criteria

[alan]

Hope someone can offer some help on this. I want to create
a parameter query that prompts the user to provide
multiple values for a single field. For example, on a
field called OrderNumber rather than have the parameter
query request and accept a single number like 12345, and
return only the details corresponding to that value when
the query is run, is it possible to have the parameter
dialog box accept multiple numbers, like 12345 78756 97666
75766 24345 etc., and return the details corresponding to
all these values simultaneously when the query is run?

I know I can set criteria easily this way in the query
design grid but the query is to be used by inexperienced
staff and I do not want the query design grid accessed.

TIA

 

[[MVP] S. Clark]

That's far too advanced for the parameter query. You'll need to create your
own form to do the work.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-