K
kansaskannan
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 - say - 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.
much (in dollars) they have purchased of various products. How do I
write a SQL statement to select customers who make up - say - 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.