Generating a report that shows exceptions

[AJ Raiber]

If you have this searching for null in all three querries
at once, you will only get returns if all three fields are
null. If you want one report that will show you records
that are null in any one of those three areas, then I
would suggest making one query for each null field pulling
those records with a null value in only one filed at a
time and then doing a union select query to combine your
answers into one query and then into your report.

HTH

AJ Raiber