Hi,

I've got a database for tracking asset movements. There are multiple entries for each asset and my problem is I would like to create a report whereby we know where each asset is at that moment in time, i.e. deployed, repair, faulty etc. I have got the report to work for all asset tracking entries but it is only required for the latest (date) entry for each asset. Is there a way of applying a script to the layout so that only the latest occurence for each asset is taken into consideration?

Hope this makes sense - any help greatfully received!!

Thanks

If you have a table of Assets and a related table of Movements you could use the Last function to get the last enter data in the Movements table and print your report from the Asset table.

Hi

I'm fully aware of the algorithm here is borrowed from Michail Edoshins "Fastsummaries" but it's so much easier with a template than explaining it ...so take a look at the upload here!

--sd

assettracking.zip

Aah, Good stuff. Thanks S