Paul, I know how confusing Access is compared to Excel, especially Query SQL.
But Queries are very powerful, as is VBA, plus you can actually combine them.
I think I must have misunderstood your requirement, as I though you just wanted the very last record in the table.
So can you provide some dummy data, preferably in an Acces 2007 format database or an Excel Spreadsheet of how you store the data and which parts from which records you want to extract?
I suppose you know Excel can link directly to Access Queries?


ps I see that you are also in Wales, but what are you doing posting at 4 am?