I have a table tracking serial numbered parts by location. There are many records per serial number. I need my report to only show the most recent entry for a serial number. Currently, when the report opens the user is prompted for the serial number. Then all the records for that serial number are displayed. I just need the most recent.