Help

How to return only the Latest Date record

Topic Labels: Base design
5760 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Poor1
4 - Data Explorer
4 - Data Explorer

I have a basic two table design: tblACCOUNTS and tblACTIONS. The tblACTIONS has these fields: Description, Date, Status, and Account. The latter is the link back to the tblACCOUNTS records.

tblACTIONS will have lots of records for each Account, but typically only a few with Status=Open and only one with Status=Open AND the most recent Date for that one Account.

I want to have two fields in the tblACCOUNTS that show me the latest Action record Description and Date, where these query/filter criteria apply (in pseudo SQL):

  • FOR EACH Account
  • WHERE Status=Open AND DATE = Latest

the result being my tblACCOUNTS shows not only my tblAccount native fields, but also the date and description of the “last action” (as defined in the above pseudo SQL) for that account on the one row.

Can I do this? How?

Tks.

1 Reply 1

Welcome to the community, @Daniel_Poor1!

Check out this thread, which will likely help you: