Hi,
im trying to create a query that will return the most recent record based on a unique number
here is me table set up
TblEventPartsLocation
EventTrackableParts_ID
EventTracker_IDFK
Vehicle_IDFK
Part_IDFK
PartLocation_IDFK
TimeStamp
TblPart
Part_ID
SerialNumber
Quantiy
TimeStamp
TblVehicle
Vehicle_ID
VehicleName
TimeStamp
TblPartLocation
PartLocation_ID
PartLocation
TimeStamp
TblPart.Part_ID is linked to TblEventTrackablePart.Part_IDFK
TblVehicle.Vehicle_ID is linked to Tbl.EventTrackablePart.Vehicle_IDFK
TblPartLocation.PartLocation_ID is linked to Tbl.EventTrackablePart.PartLocation_IDFK
its to track parts from locations, either on a vehicle or in stores
what im trying to do is create a query to return the most recent record for a part, so TblPart.SerialNumber is my unique number, and im trying to return the most recent record from TblEventPartsLocation, every time a part is added or removed from a vehicle or stores an entry is added to this table, im having trouble just returning the most recent record for TblEventTrackerPart.SerialNumber. this is to be used as a query for the combo box in both AddPart and RemovePart form, when there are no parts left allocated to stores, the combo box will return no records
im trying to create a query that will return the most recent record based on a unique number
here is me table set up
TblEventPartsLocation
EventTrackableParts_ID
EventTracker_IDFK
Vehicle_IDFK
Part_IDFK
PartLocation_IDFK
TimeStamp
TblPart
Part_ID
SerialNumber
Quantiy
TimeStamp
TblVehicle
Vehicle_ID
VehicleName
TimeStamp
TblPartLocation
PartLocation_ID
PartLocation
TimeStamp
TblPart.Part_ID is linked to TblEventTrackablePart.Part_IDFK
TblVehicle.Vehicle_ID is linked to Tbl.EventTrackablePart.Vehicle_IDFK
TblPartLocation.PartLocation_ID is linked to Tbl.EventTrackablePart.PartLocation_IDFK
its to track parts from locations, either on a vehicle or in stores
what im trying to do is create a query to return the most recent record for a part, so TblPart.SerialNumber is my unique number, and im trying to return the most recent record from TblEventPartsLocation, every time a part is added or removed from a vehicle or stores an entry is added to this table, im having trouble just returning the most recent record for TblEventTrackerPart.SerialNumber. this is to be used as a query for the combo box in both AddPart and RemovePart form, when there are no parts left allocated to stores, the combo box will return no records