I have a database started to track an asset that can go out for repair and back in and then stored. When needed it would be removed from storage and placed in use. I have a serial number for each asset and want a query to pull the latest record for each serial number. This will tell me where each asset is at that time becuase i enter a new record each time the location changes. I have only around 90 serial numbers but hundreds of records for the 90. Any help would be greatly appreciated. Thanks