Hi. How do you do a find for the newest records? I don't want to do a date lookup, because I don't want to have to go into the database and try to figure out when the latest records were created. All I want to do is display the newest records for each client I have. Can this be done via a find?

thanks.

Unsorted databases list the records in creation order -- oldest first, newest last. So find all records, unsort, then go to the last record to find the newest record.

Thanks. Actually, it is not the newest created record I need, but the latest by date. So if I have records for clients a, b and c, I need to search for the latest records for each of them. So if 7/21/04 is the newest record I created for each of those clients, I need a button that says "display latest records" or something like that, and the records for 7/21 will be found for each client.

Any ideas on how to do that? thanks.

You could use a self-join relationship.