Page 1 of 1
Most Recent Record
Posted: Thu Dec 16, 2004 10:55 am
by Barbara
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!
=> RE: Most Recent Record
Posted: Thu Dec 16, 2004 10:13 pm
by Rick_W_Johnson_(Guest)
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
==> RE: Most Recent Record
Posted: Fri Dec 17, 2004 3:48 pm
by Barbara
This worked...__Thank you