Is there a simple way to use a query to create a matrix in a report. I need to gather data from 12 months and 12 different catagories. I used count functions last time but this matrix will be far larger. I used this function
CountAug: ([Date Settled]) Between #8/1/2003# And #8/31/2003#
and then did a dsum function to come up with the total. I hope I don't have to do 144 functions within one query. Any idea's?