>I'm using VFP to connect to an SQL database via ODBC so I can't use the IIF() because it's not understood by the ODBC connect.

Hi Robert, I don't know if it's SQL6.5 compatible but this should work:

Sum(Case When Month(SomeDate) = 1 Then Amount Else 0000 End) As Jan, 
....