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