Hi Sergey,

>Based on the info you provided a query with grouping by month would be the best solution.

Thanks Sergey - that would also work.

Just as soon as I posted the question, it dawned upon me that I could sum each field, and use an expression of:

IIF(MONTH(SaleDate) = 1,SaleAmt,0)

for column one, and similar for the other monthly columns.

Mel Cummings