How to get the 20 MOST and LEAST profitable customers from an OLEdb into Listboxes 1

Gentlemen:

Could you please let me know the right code for extracting the 20 top most and 20 least profitable customers using the SALES column in Database1 into listbox1 and 2?

On listbox1 I need to show:
20 MOST PROFITABLE CUSTOMERS
TotalAmount / CustomerName / CustomerCity

On listbox2 I need to show:
20 LEAST PROFITABLE CUSTOMERS
TotalAmount / CustomerName / CustomerCity


Thanks

Andy

I’m using:
VB.NET 2003 Standard
Access 2000

Most profitable-
SELECT Top 20 TotalAmount, CustomerName, CustomerCity FROM Database1 ORDER BY Sales DESC
Might have trouble with negative values, not sure.
For least profitable, change DESC to ASC

To then put these into your list boxes, you need to make a data environment, with 2 commands, which are the 2 queries. Then bind the list boxes to the commands

karsh44:

Thank you for you reply:

Question:

Do you think this query will add all the values of all the sales corresponding to a specific customer?

What I mean is most customers have many sales, would the query first Sum all sales for each customer and then select the top 20?

No. As the query is now, it will simply sort all the orders in decending and ascending order, no summing included. I don't use Access much, I think there's a wizard or something that might do that automatically.