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

[piscis]

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