emerywang Posted July 21, 2004 Posted July 21, 2004 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.
Vaughan Posted July 21, 2004 Posted July 21, 2004 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.
emerywang Posted July 22, 2004 Author Posted July 22, 2004 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.
Recommended Posts
This topic is 7429 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now