access 2000-multiple criteria search

M

martin

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!!!


.
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top