I am building a report that gives the user the option of going back a certain number of days that they would enter. Say they want to see all of data back to 1/1/2009. Or maybe go back to 4/1/2008. So what it would do is count the number of records for each month. Say Jan 08 may be 150, Feb 08 something like 125, etc. This is pretty simple using a totals query. Unless there are some months with no records. Using a totals query you end up with the entire month missing in the result. And this causes problem in the chart where I would like to see a '0' for that month.
So.... Is there a trick out there that I may not be aware of? The only way I can think of to do this is to create a temp table, populate it with period data, etc... ugh