>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,
....