G
Guest
Here is the basic output of the crosstab query. The column headings comes
from a DateSerial(Year(XXX),Month(XXX),1) to get totals by month:
ID 10/1/2005 11/1/2005 12/1/2005 -> etc. through 12 months total
1115 359.216 78.901 12.789
1789 243.894 123.400 597.189
1934 12.774 1549.271 9.781
I tried setting column headings for my crosstab query as:
"ID", "Month1", "Month2" etc. -> "Month12"
but that gives me a "Data type mismatch in criteria expression".
I also tried just "Month1", "Month2" etc. -> "Month12" to see if it was the
inclusion of the first column (my RowHeading column) that was causing the
problem, but with the same error.
from a DateSerial(Year(XXX),Month(XXX),1) to get totals by month:
ID 10/1/2005 11/1/2005 12/1/2005 -> etc. through 12 months total
1115 359.216 78.901 12.789
1789 243.894 123.400 597.189
1934 12.774 1549.271 9.781
I tried setting column headings for my crosstab query as:
"ID", "Month1", "Month2" etc. -> "Month12"
but that gives me a "Data type mismatch in criteria expression".
I also tried just "Month1", "Month2" etc. -> "Month12" to see if it was the
inclusion of the first column (my RowHeading column) that was causing the
problem, but with the same error.