Crosstab Query For Fiscal Year Totals

[DevlinM]

I want to write a crosstab query for FY totals that will show each month
regardless of wether there is data or not. Any help on this is greatly
appreciated.

Thanks!

 

[Jerry Whittle]

The trick is column headings. Open the query in Design View. Right click up
where the tables go and select Properties. In there is column headings. Put
in the expected column names in order. Something like:

"Jan","Feb","Mar" and so on.