I am using Access 2000 for a VB program with ADO 2.5. I am looking for a quick way to sort my records based on a unique, custom order. I know about the ORDER BY statement but it doesn't work in this case (or I don't know how do it...).

A stupid example would be a field called "Invoice Status". You can choose Not Paid, Open, Paid, and Unlikely.

I would want the "Not Paid" records first, then "Open", then "Unlikely", then finally "Paid". This recordset would be displayed on a grid list.

Just curious...

Eric