Cross Tab Report

[houseofturner]

I have designed a report based on a cross tab query that counts the number of units sold by each dealer per month. So the left hand column lists the dealer and the rows along the top list the months. There is then a total at the bottom.

This worked find when I was reporting on an entire year. However, the query now has a date range criteria and if this is only part of a year the report wont run because it thinks it is missing data (i.e. if the date range is 01/01/2010 to 01/09/2010 then the report fields for October onwards cant find a matching field and so the report wont run).

I was hoping the months without data would just appear with a blank in the field or an error code that I could use conditional formatting to white out.

Any ideas?

BTW it is Access 2003

 

[stopher]

You need to force the field headings to appear. Take a look here and go down to the section "Specify column headings".

hth
Chris

 

[houseofturner]

Great - Thanks

You need to force the field headings to appear. Take a look here and go down to the section "Specify column headings".

hth
Chris