Search function for customer report

[nain99]

I want to search the top customers who spent in year of 2005 and also in year of 2006 (from 1/1/2006 to 5/31/2006). How can I write the query for it?__Thank you very much

[kfleming]

Group by customer, create a total that sums sales and make it pre-processed. Query for sales year equals 2005. Then sort by the pre-processed total descending and customers will print with the top sales value for 2005 first.