I cannot find anything similar in FAQs or existing threads... please point me in the right direction if I am asking a duplicate question!
I have 2 tables. One lists truck numbers (Trucks), the other has multiple entries for each truck (Truck Activity). I need to print a report showing each truck number & it's status (latest record), like an inventory.
I wrote a query that sorts the trucks by truck number & lists the most recent record first... but how do I get only the most recent record for each truck?
I have tried some VBA code, but I feel like I am missing something easy!
I have 2 tables. One lists truck numbers (Trucks), the other has multiple entries for each truck (Truck Activity). I need to print a report showing each truck number & it's status (latest record), like an inventory.
I wrote a query that sorts the trucks by truck number & lists the most recent record first... but how do I get only the most recent record for each truck?
I have tried some VBA code, but I feel like I am missing something easy!