MIcrosoft Jet Database engine does not recognize '[January]' as a valid filed name

  • Thread starter Thread starter Santiago Gomez
  • Start date Start date
S

Santiago Gomez

I have a report based on a crosstab query.

when I filter data based on some criteria the results do not have data for
every single month. The report gives an error when it tries to populate the
control box linked to the particular month on the crosstab query.

What should I do?

Thanks
 
Santiago said:
I have a report based on a crosstab query.

when I filter data based on some criteria the results do not have data for
every single month. The report gives an error when it tries to populate the
control box linked to the particular month on the crosstab query.
Click to expand...


In Query Design, display the query's proerty sheet (View
menu) and set its Column Headings property to the list of
months. Only months in the list will be displayed, whether
there is any data for a month or not.
 
thank you very much.

Marshall Barton said:
In Query Design, display the query's proerty sheet (View
menu) and set its Column Headings property to the list of
months. Only months in the list will be displayed, whether
there is any data for a month or not.
Click to expand...
 
Back
Top