Report - How to deal with Missing Data

[tmartin]

I have attached a prototype where there are two queries. I have a field called Type in the table temp that can have three values (PAYMENT, ENDORSEMENT, or NEW BUSINESS)

HOw do I modify the report for the situation whereby not all three TYPE's might not be exist for the query.

[ItsMe]

Perhaps the Nz() function is what you are looking for.
https://msdn.microsoft.com/en-us/lib.../ff195223.aspx

[tmartin]

Problem Solved! Hurray ..... Found the solution while searching online and implemented the change, It worked
If your query requires a fixed set of columns and the query returns less, then input a list of the default Column Headings required for the report

Solution is:

Go to Cross_Tab Query
Select Design View
Select Properties
Select the column of interest
Under properties add "ENDORSEMENT";"PAYMENT";"NEW BUSINESS" to Column Headings