Page 1 of 1
Search function for customer report
Posted: Thu Jun 15, 2006 4:31 pm
by 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
=> Search function for customer report
Posted: Mon Jun 19, 2006 7:12 am
by 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.