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 and can be "MET", "NOT MET", and "PARTIALLY MET".
The problem is this:
User selects a time frame, if the GOALS that apply for that time frame has 1 of the 3 or 2 of the 3 Goals missing, then an error appears for the missing Goal
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.
The crosstab query: "Column Heading" is GOAL. A GOAL is selected by the user and can be "MET", "NOT MET", and "PARTIALLY MET".
The problem is this:
User selects a time frame, if the GOALS that apply for that time frame has 1 of the 3 or 2 of the 3 Goals missing, then an error appears for the missing Goal
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.
