Using AND in Queries

  • Thread starter Thread starter greg.kylelangley
  • Start date Start date
G

greg.kylelangley

I've a database detailing various suppliers [tblSuppliers] and the
things they can do [tblCapabilities]. These are linked by
[tblSupplierCapabilityLink].

I currently have a working search form [frmSearchCapability] allowing
the user to select up to four capabilities from four combo boxes. The
form then updates a list box with all the companies that have ANY ONE
of these capabilities - an OR search.

I need also to provide an AND search - so only the companies that have
ALL the specified capabilities are returned. I'm happy with the results
of this appearing in a different list box, or even a different form,
but I can't get the search to work. The OR search currently has the
following criteria:

[Forms]![frmSearchCapability]![comboCapability] Or
[Forms]![frmSearchCapability]![comboCapability2] Or
[Forms]![frmSearchCapability]![comboCapability3] Or
[Forms]![frmSearchCapability]![comboCapability4].

How can I get the AND search to work in a similar way, ignoring Null
responses?

Any help -very- gratefully received!

Greg
 

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

Using AND in Queries 7
Access Need help in making asset history in my current database. 1
Query using text from form or anything if empty 2
help with query criteria with multiple chk boxes 5
Access Determine what query to run based on a checkbox 0
If Statement with "*" in Query 2
Parameter Query 7
MS Access problem 0

Back
Top