Skip to main content
Question

Reporting most recent data from two linked tables

  • September 26, 2017
  • 0 replies
  • 40 views
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.
    This topic has been closed for replies.

    No problem, just open up the relationship and use the button on the left to Create Summary field.

    Do a maximum of the [Activity Date] field.
    Terms & ConditionsAccessibility statement