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.

U can set the criteria of your datefield:

Max([YourDateField])

or

U can also use:

Last([YourDateField])

HTH
Daniel

Thanks for the help.

No problem, anytime

Daniel