Create maximum date field that looks at all transactions

To get the global maximum, make a new table called Maximum Transaction Date.
Make a single record.  It will be Record ID# 1.

In the transactions tale make a formula numeric field called [Link to Max Transactions Date (=1)], and give it a formula of 1.

Use that field as the reference field on the right side of a new relationship to that Max table and make a Summary of the Maximum date and look that up down to all detail records.