Hi All
I am new to the forum and this is my first post.
I am using MS Query to extract data from an Asset Database to an excel spread sheet.
The data being used is a list of assets and their movement over a period of time.
Is there a formula I could use to extract all the assets (Unique Ref is "Serial_Number"), but only the latest dated ("entry_data") line of data for that asset.
Many thanks
Diane