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
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