Crosstab query as source for report

[Amileaux]

In order to get months across on my report, I have resorted to using a crosstab query as my source. However, if I don't have data for a certain month I get an error when I try and open the report "The Microsoft Jet Engine Database does not recognize "Nov' as a valid field name or expression". I can open the report up in design view - and the problem is fixed by going an placing zero in the month of Nov. However, I need to figure out how to make this work more "elegantly" since others use this and they may not have data for the month of "Nov". I want all months across to show - regardless if there is data or not. Any thoughts? Maybe I shouldn't have used a crosstab query. Marie

 

[jtvcs]

Try going into the Query properties, Column Headings property and enter all the months Jan, Feb, Mar separated by commas -- think this will help you.