Reporting most recent data from two linked tables

Hey everyone!

I am trying to build a report that links two tables. One table contains the information for our clients (accounts). Embedded in the data entry section is a table to link activities as well as add new activities (please see the attached photo).


I am struggling to create a column that lists the most recent activity date for each account. Is there a way to do this? Any help would be appreciated!

Thank you.