Multiple search criteria

D

Dave

Hi all,

My database has a table with 10 fields. I would like to produce a
query that allows me to do a search based on any one of these fields,
using wildcards. The wildcard bit is not a problem. However, Access
seems to have a problem with so many possible criteria. Is there
another approach one can take?

Dave
 
A

Allen Browne

Access can handle more than 10 criteria, but you must explicitly handle
gettting it to return the records where the fields are null.

For an alternative approach, see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
 

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

Similar Threads

Access Dcount (multiple criteria) 3
Date search query 0
Query based on Check Box 1
Q: query asks for parameters multiple times 4
how i search a data in multiple querys? 1
query criteria 2
Multiple Criteria Search Form 3
Dynamic search criteria from an array? 1

Top