Generating an Exception report

[Judy]

I have a user that needs to generate a report based on
certain fields having Null values. For example she 3
fields FileName, FileNo and LoanNo, if one or more of
those fields are blank, she would like a report to
generate that would show:

FileName: JSmith, FileNo: (blank), LoanNo:2345

These fields are in one table. Thanks

 

[Marshall Barton]

I have a user that needs to generate a report based on
certain fields having Null values. For example she 3
fields FileName, FileNo and LoanNo, if one or more of
those fields are blank, she would like a report to
generate that would show:

FileName: JSmith, FileNo: (blank), LoanNo:2345

These fields are in one table.

Create a query that returns the desired records. Just set
the criteria row for FileName to
Is Null
and enter that **on different rows under the criteria row**
for the other two fields. If you switch to SQL view in the
query design window the Where clause should something like:

WHERE FileName Is Null OR FileNo Is Null OR LoanNo Is Null

The report itself should be trivial. To get the text boxes
to show "(blank)" for Null values, set their Format property
to a custom format of:
@;"(blank)"