Multiple search criteria

  • Thread starter Thread starter Dave
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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
Wildcard Table 4
How assume wildcards in a query criteria 3
Query based on Check Box 1
Record contains wildcard char 2
wildcard for date criteria to return all records 1
Dynamic search criteria from an array? 1

Back
Top