>I would like to use sql to calculate the sum(SomeField) but broken down by Jan-March , April-June , July-Sept and Oct-Dec.
>
>Do I need four seperate sql statements and then merge the tables together.
>
>TIA
Asumming that table1 has two fields: num I, date D:
Select ceiling(month(date)/3) as quarter,sum(num) as sumnumber from table1 group by 1
Edward Pikman
Independent Consultant