display column w/o data

[jmnekrkt]

I'm trying to create a cross tab query that will display all the days of the month even if some of the days have no data. I remember being able to specifiy column names in the past (I used it to order months chronologically instead of alphabetically) but can't find how to do.

Thank you

 

[RobCPA]

If you open the query in design mode, choose the menu item of View -> Properties, you should see a box that has the title of Query Properties. The third property is 'Column Headings'. You can fill this in manually to force a column heading even if it doesn't have any data. This can also be done programmatically from VBA code.

Rob