Show Last Record with All Columns

[Computerpak]

I am trying to retrieve the last record inserted into an Access database. I have created a field in the table that uses the AutoNumber function to create a new ID for each record. When I try to retrieve this last record by using "Last" function and setting TOP value =1, all I can get is the ID field. How do I retrieve all of the fields
from the table.

 

[jdegeorge]

What fields are you putting in your query? If you're only putting in the one field that you have the LAST criteria on that's all you'll get.

Jim DeGeorge

 

[Computerpak]

Following are the fields in the Table Inventory
Item_id is autonumber Field
ItemDetail
ItemType
Qty
Price
Remarks

 

[dhookom]

SELECT TOP 1 *
FROM Inventory
ORDER BY Item_ID Desc;

Duane
MS Access MVP

 

[Computerpak]

Thank you very much, it really worked.
It was a good experience