Multiple search criteria

[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

 

[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