4 columns data is null or no data those records fail and remaining pass.

[Nagaraju_kanna]

Hi,

If below columns data is null or no data those records fail and remaining pass.
EMP
NAME
Employer
Occupation

Expected Output

Total record 8

pass records with data

fail records with data

[Nagaraju_kanna]

If below columns data is null or no data those records fail and remaining pass.
EMP
NAME
Employer
Occupation

[Peachyco · Accepted solution]

If I understand you correctly, you want a pass/fail flag if any of those specific fields are null.

Your formula would be:

IF IsNull([EMP]) OR IsNull([NAME]) OR IsNull([Employer]) OR IsNull([Occupation])
THEN 'Fail'
ELSE 'Pass'
ENDIF

[Nagaraju_kanna]

Thank You..

[Nagaraju_kanna]

Hi Peachyco,

Thanks for resolved my previous one.

Now requirement is BLANK columns are Prefix, PHONE, Mailname and HomeAddress1 should pass

these columns also need to mention in single query like 

IF IsNull([EMP]) OR IsNull([NAME]) OR IsNull([Employer]) OR IsNull([Occupation]) or
IsnotNull([Prefix]) OR IsnotNull([PHONE]) OR IsnotNull([Mailname]) OR IsnotNull([HomeAddress])
THEN 'Fail'
ELSE 'Pass'
ENDIF

please resolve my query