surely someone must have had this problem and has a solution for it.
I want to make a report off a crostab query. the report lists incidents per unit and sums them per unit. I would like to make a report I can show from the ctquery but the incidents will vary per month although they are all indexed in a table. The problem is how do I format the fields on the report if I don't know in any month which incidents will happen and be picked up by the query. if I have a data box in the report that references an incident in the query it will generate an error if no incident of that type happened in the month and so is not listed in the query. Is some code of the type- on error ,if field does not exist in ctquery make field = "0" what I need?