Question Data analysis using Cross tab

[Lanason]

I have a bunch of data and I want to create totals per month.
When I use the cross tab it works fine BUT if there is a month with no records it misses the month out rather than reporting Zero. Is there an easy way of including a zero?

 

[theDBguy]

Hi Adrian,


You can include all the months by specifying them in the Column Headings property.

 

[isladogs]

Depending on how you calculate your totals, you may need to use e.g. Nz(Totalsfield,0). Without that it may just be blank (null)

 

[Lanason]

I am actually using rolling 12 months in the output

 

[isladogs]

In that case you need dynamic column headers.
Have a look at the method i use to deal with that.
For example https://www.access-programmers.co.uk/forums/showthread.php?t=294548
The idea is transferrable to any crosstab report without fixed headings