Crosstab report - handling Null fields

J

Jason

I've got a report based on a crosstab query reporting monthly data. The
problem is, if I have not put in any data for one of the months, I get an
error "The Microsoft Jet database engine does not recognize " as a valid
field name or expression."

Any ideas on how to handle this?
 
D

Duane Hookom

You can enter all possible months into the Column Headings property of the
crosstab query.
 
Top