Crosstab report - handling Null fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You can enter all possible months into the Column Headings property of the
crosstab query.
 
Back
Top