Posted by kansaskannan on 10/18/06 01:08

I have an Access 2000 database which lists customers by name, and how
much (in dollars) they have purchased of various products. How do I
write a SQL statement to select customers who make up the top 60% of
total sales dollars? I need to have a list of customers returned.

The list of customers that get returned will be used to select other
data from the same database. (I mention this in case there are multiple

ways of getting the customer list).


Thank you for any advice.

• Next in forum: SQL statement to compare and return one aggregated value
• Prev in forum: Re: Using trigger to notify an assembly of changes.
• Thread view: sql statement to select customers contributing top 60% of sales

[Reply to this message]