Selecting current Assignments

[sspradl]

Help please. I have a database with patient authorizations to various providers. They may have more than one authorization on the same day. I need to select the patient and the most recently assigned provider (other selection criteria will also be used). Data may look something like:
Authno Authdate Membno Provnam
1 20050201 100 AMH
2 20050402 200 Seton
3 20050404 100 Seton
4 20050404 100 Seton
5 20050501 200 AMH

I need the result to show:

100 Seton
200 AMH

 

[edtab]

You'll have to loop through your recordset and examine the values of each entry for the fields "Provnam" and "Authno". You also need to sort your recordset first on "Provnam" Ascending. This will bunch all the like entries one after the other so that you can loop through each individual provider name and pick the one with the highest "Authno". You may dump it into a text file or insert into a table which will be the basis of your report.