I report from an original crosstab query. Last year it (december) it was created to to account for data each month. The report was created which they still want to use.
However, the report has existing "column" headings labled Jan Feb March Apr May etc etc
Now - when we run the report looking for the months in 2006 and NOT 2005 (where there are 12 months of data) the report fails to operate because it can find months where there was no data for insstance Jan to Aug is ok - there is data but Sept has nothing and because of this the crosstab query cannot sent anything to the report. so the report fails to load. September Does not exist (yet). I cannot put dummy information in to the tables - to allow it to at least report zero (0). So, I'm thrying to find a way to make either the crosstab produce the zero or that the report sees that their is no record for that month to report and just places a zero in the text box - thus allowing the report to function without having to create a report for each month
Do your crosstab on another query rather than the table
If you use another query such that (you have to get a little creative here depending on the data), and you have a one to many relationship defined, you can then do something like iif(isnull([date]),0,[date])
Then you can do a crosstab query on the results of that query.
For any further detail I'd have to look at your application.
I sumise that if I use this format it could go in to aprimary query, (one that gathers the data for a crosstab)? Then it should force the crosstab to create a zero where the not yet reached data is to occur