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...