I have a db that tracks vins and when they were moved. There are 2 tables, one with all the history of a VIN (which includes the date/time stamp the unit was moved) and a second table that contains inventory information based on the last move made.
I have written a report to track units older than 24 hours but because I have to link to the VIN history table the report is pulling all of the records for each time the VIN was moved.
How can I pull the most recent record???
Thank you in advance for any assistance.