Discussions

Expand all | Collapse all

Reporting most recent data from two linked tables

  • 1.  Reporting most recent data from two linked tables

    Posted 09-26-2017 19:08
    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).
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1654636/RackMultipart20170926-21914-1oys2wx-Screen_Shot_2017-09-26_at_2.04.17_PM_inline.png?1506452718">

    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.


  • 2.  RE: Reporting most recent data from two linked tables

    Posted 09-26-2017 19:28
    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.


  • 3.  RE: Reporting most recent data from two linked tables

    Posted 09-28-2017 14:24
    This worked! Thank you for the help.