You might want to post this on the Access forum.
I'm a novice but I have created a query in Access and exported it in an
Excel format. So it can be done. I don't know how to limit the query to only
your last record.
> not sure how to even approach this, what I have is a table in access that I
> only want the last record to lookup or import into excel from access is this
> possible?
>
> Thanks in advance