COMPARE TWO FIELDS IN A QUERY

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with 2 fields that are check boxes. What I want is my query
to compare both fields and only display that record if EITHER is a "no"
condition, but filter out if BOTH are "yes"
 

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

IIF statement to compare two fields. 3
comparing two tables with the same field 10
Excel Comparing two columns 1
Comparing multi select list box criteria against two fields 4
Compare same fields in two queries 5
Simple Query Expression 4
Query comparing two fields in a table gives wrong results-why? 3
Compare (2) fields in (1) table 4

Back
Top