A
antmorano
Hi I am trying to create and And statement and this is what I
currently have:
[Status of Coverage- Retiree]<>"CANCELLED" And [Status of Coverage-
Spouse]<>"CANCELLED" Or Is Null
What I am trying to do is if Status of Coverage- Retiree equals
"CANCELLED" and Status of Coverage- Spouse equals "CANCELLED" or is
null then skip the record.
If there is a cancel in both fields then I need the record to be
skipped.
currently have:
[Status of Coverage- Retiree]<>"CANCELLED" And [Status of Coverage-
Spouse]<>"CANCELLED" Or Is Null
What I am trying to do is if Status of Coverage- Retiree equals
"CANCELLED" and Status of Coverage- Spouse equals "CANCELLED" or is
null then skip the record.
If there is a cancel in both fields then I need the record to be
skipped.