Using script to create report....

[scarnie]

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

[RalphL]

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.

[Søren Dyhr]

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

[Ender]

Aah, Good stuff. Thanks S