If you only have one years worth of data, otherwise you'll need a reference to the year also
Peter
>Hi Cathy,
>
>I figured it out by suming each field in the report writer, and using an expression of:
>
>
>IIF(MONTH(SaleDate) = 1,SaleAmt,0)
>
>for column one
>
>IIF(MONTH(SaleDate) = 2,SaleAmt,0)
>
>for column two, etc., etc.
>
>Mel Cummings
Peter Cortiel