G
Gus Chuch
How can I write a single query to replace the two that I’m using now to find
and show only the last record entered?
SELECT [tblEquipment Query].LastOfEquipmentID, tblEquipment.Description,
tblEquipment.Manufacture
FROM tblEquipment INNER JOIN [tblEquipment Query] ON
tblEquipment.EquipmentID = [tblEquipment Query].LastOfEquipmentID;
and show only the last record entered?
SELECT [tblEquipment Query].LastOfEquipmentID, tblEquipment.Description,
tblEquipment.Manufacture
FROM tblEquipment INNER JOIN [tblEquipment Query] ON
tblEquipment.EquipmentID = [tblEquipment Query].LastOfEquipmentID;