Shows the last record entered.

[Guest]

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;

 

[Guest]

Probably need to show us tblEquipment Query also.

The big question is what do you mean by 'last'? Do you have something like a
date/time field that shows which would be the latest record entered? The
order that you type records in a table has no meaning in a relational
database. You need something like a date/time or some number that increments
to show the latest record. You really can't trust autonumbers increment
larger. I've even seen an autonumber throw in a negative number before!