Pivot Table - Query - Last Records
I have a log of sorts. Each log has a unique key pair (two values) and based on random dates, I add an entry.
For example:
Item 1 - Sub Item 1 - 01-01-2019 - value1, value 2
Item 2 - Sub Item 2 - 02-13-2019 - value1, value 2
Item 1 - Sub Item 1 - 06-05-2019 - value1, value 2
Item 1 - Sub Item 1 - 07-01-2019 - value1, value 2
Item 2 - Sub Item 2 - 04-14-2019 - value1, value 2
I only want to produce a report that is based on the key pair - Item # plus Sub Item # for the last date.
So the report would only show:
Item 1 - Sub Item 1 - 07-01-2019 - value1, value 2
Item 2 - Sub Item 2 - 04-14-2019 - value1, value 2
Any suggestions?