two different time ranges

[dylan_dog]

Hi,



I have a table that contains multiple records containing purchases dated between years 2010 and 2011 a joined table with customer data. Is it possible to create a single query that sums the purchases for every customer in one column for 2010 and in another for 2011?

Thanks

[June7]

A crosstab query will accomplish that. Use the query wizard to build one.