Last record row in a query

[LOUIX]

Hi All,
I'm quite new in access, I have a table with several fields.
My table have a unique ID, a Branch ID( may contains duplicate values), Mileage, Authority No, and a Date field
I want to extract only the last value inserted per Branch ID for all the fields as per the attachment.
I don't have any clue have to do it, can you please help
if you need more info , don't hesitate
File attached
Thanking you
Louix

[moke123]

try this

SELECT tblGoodwillSub.ID, tblGoodwillSub.BranchID, tblGoodwillSub.strLabWarranty, tblGoodwillSub.strPartWarranty, tblGoodwillSub.strLabLeal, tblGoodwillSub.strPartLeal, tblGoodwillSub.strLabCustomer, tblGoodwillSub.strPartCustomer, tblGoodwillSub.txtVin7, tblGoodwillSub.txtMileage, tblGoodwillSub.txtAuthority, tblGoodwillSub.dtValid, tblGoodwillSub.Count
FROM tblGoodwillSub
WHERE (((tblGoodwillSub.ID)=DMax("ID","tblGoodwillSub","BranchID = " & [branchid])));

[LOUIX]

Moke123
Ohh my god
You are a genius, you saved my life
Thanking you very much

[pbaldy]

Welcome to the site. FYI, I deleted your duplicate thread. In the future, there's no need to post the same question twice.

[LOUIX]

pbaldy
Well noted
sorry for inconvenience
Thanks
Louix