Show only last value / entry

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I have two tables in one to many relationship, and idea is following:
- One project can have many log entries.
I know how to create a table report, and sort, but what I need is a way to show only the date of last entry for the project? 

Can this be done, and how?

Thank you.
Photo of Nenad Ilic

Nenad Ilic

  • 734 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 2,100 Points 2k badge 2x thumb
I think you could try a summary field and setting it to Maximum Record ID. That should be the most recent related record. 
If you want to know the maximum of the date field in a child table then make a summary field on the relationship  of the maximum of the date field in the child table.
if you just want to show the whole entry for the log child table but only show the  entry which is the last one, then  do that summary date field and look it up back down to the Log entries.

Then filter the embedded report where the date = summary maximum date.