Reporting most recent data from two linked tables

  • 0
  • 2
  • Question
  • Updated 1 year ago
  • Answered
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.
Photo of Adam Collins

Adam Collins

  • 112 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,346 Points 50k badge 2x thumb
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.
Photo of Adam Collins

Adam Collins

  • 112 Points 100 badge 2x thumb
This worked! Thank you for the help.