I have a report where the underlying data is a crosstab query and based on user input of time frame.
The crosstab query: “Column Heading” is GOAL. A GOAL is selected by the user where the choices for GOALS are “MET”, “NOT MET”, and “PARTIALLY MET”.
The problem is this:
User selects a time frame, if the GOALS that apply for that time frame don’t have all 3 GOALS (Met, Not Met, Partially Met) then an error appears for the missing Goal(s).
Currently I’ve tried to use Nz function but still it doesn’t recognize a GOAL that isn’t listed.
What must I do to supress the issue when NOT ALL 3 GOALS are part of the data?
Thanks for any suggestions.