Most Recent Record

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Barbara
Posts: 7
Joined: Tue Oct 10, 2017 12:44 pm

Most Recent Record

Post by Barbara » Thu Dec 16, 2004 10:55 am

I am looking for a way to pull the most recent/last record in the database. My database contains history rows. It appears to me that R&R pulls the first record it finds fitting my filter. __I did not see any function that looked like it might work. Any ideas!

Rick_W_Johnson_(Guest)
Posts: 22
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Most Recent Record

Post by Rick_W_Johnson_(Guest) » Thu Dec 16, 2004 10:13 pm

If you have any type of sort, go into the sort listing and just uncheck the Ascending box. Then, your first record read will be the last one of the filter.____Not sure this will work, but if there is no sort, you could play with the concept of Recno() = Reccount(). Depends on how the records are kept, but the last record of a packed file is the same as the record count.____Not sure I helped, but maybe gave a hint.____Good Luck

Barbara
Posts: 7
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Most Recent Record

Post by Barbara » Fri Dec 17, 2004 3:48 pm

This worked...__Thank you

Post Reply