Skip to main content
Question

Show only last value / entry

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

    • ChuckGrigsby
    • Registered
    • September 5, 2017
    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.
    Terms & ConditionsAccessibility statement