Shows the last record entered.

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;
 
J

Jerry Whittle

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top