access 2000-multiple criteria search

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

can anyone help?!

I am not a particularly advanced user of access 2000, but
would like to know how to put a multiple string into the
criteria box in the query section. For example:when
running a query for serial numbers...how do i ask for more
than one, and give specific serial numbers of each one?

Thanks!!!
 
The criteria would need to contain multiple OR operators.

For example:
WHERE SN=1234 OR SN=2345 OR SN=4324

Other way is the IN clause
WHERE SN IN (1234, 2345, 4324)

If you are still trying to use a parameter query, then please understand
that you are surpassing it's designed capabilities.


--
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
I was wrong you can do '[enter serial #] or [enter serial
#1]' in the criteria and it will work.

Martin
-----Original Message-----
In the serial # box of your query, in criteria, you would
put 'serial#1 or serial#2' or '1234 or 4567'. As far as
asking for 2 criteria (ie [enter serial #:] in criteria)
from a query on the same field I don't think it can be
done with access. You would have to use a form to get 2 or
more criteria on the same field.

Martin
-----Original Message-----
can anyone help?!

I am not a particularly advanced user of access 2000, but
would like to know how to put a multiple string into the
criteria box in the query section. For example:when
running a query for serial numbers...how do i ask for more
than one, and give specific serial numbers of each one?

Thanks!!!


.
Click to expand...
.
Click to expand...
 
Back
Top