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