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

[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

 

[Marshall Barton]

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.

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.

 

[Santiago Gomez]

thank you very much.

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.