I need a SQL statement that will select a list of UNIQUE endors from a table and order them by last pay date. I am pulling the VENDID, VENDNAME, INVNUM, CHKNUM,CHKDATE,DTOS(CHKDATE), and CHKAMOUNT from a single table (CD). A simple select distrinct will not work because each vendor has multple records for different INVNUM's. Help Please
Fred Lauckner
You know, it works on my computer. I don't know what your problem is.
.Net aint so bad.