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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Does not recognize " as a valid field name or expression 1
Crosstab report - handling Null fields 2
Crosstab report - handling Null fields 4
MS Jet DB engine does not recognize 'my query name' as a valid name 7
Report based on filtered crosstab 5
Using select and crosstab queries on one report 1
Wizard crosstab report failure 1
Report Error for certain Crosstab Query 2

Back
Top