Query Expressions

  • Thread starter Musa via AccessMonster.com
  • Start date
M

Musa via AccessMonster.com

I have a Query set up to Export the following 8 variables if they meet the
following conditions:
Date = Is not Null
Living = Is not Null
Issues = 12
service = >0
Outcome = > 0
FirstName = Is Not null
LastName = Is Not null
Complete_dt = Is Not null

This query works perfectly fine.

Now, I want to add another Criteria to another variable [Refused_tx].
If Refused_tx = 1 ( regardless of the above criteria, export along with the
records above).
How would I add this additional criteria without losing the Non refused tx
records or where Refused_tx = Null ?

Thanks
 
K

KARL DEWEY

Open query in design view. All of the current criteria should be in the same
row.
Add new criteria of =1 in different row.
 

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

Top