It would have helped to know on which of these table occurrences you based your layout, but there is indeed a function that returns the value from the last related record. It's called Last(). But it has one key limitation: it returns the value from the last related record where the value in the field is not blank so this is a detail to keep in mind when you make use of it.
PhilModjunk, I regret that I did not provide all the necessary information; however, your response using the Last(field) function was exactly what I needed. I was able to modify the Assets table to add a Last Patron field. When I added this field to the report layout, I created a very simple script that called the Last(table name::field). After testing repeatedly, this appears to solve all of my problems.
Thank you for your quick assistance.