Web Database report

[gemadan96]

At a client's request I've converted an asset tracking database to a web database. In it I have a web query of all transactions and various details of each transaction.



What I need to do is create a report from that query that shows all assets that are currently checked out. There is a date/time stamp for each transaction and it is either designated as checked in or checked out. There is a history for each asset, meaning there are several entries for each asset. So basically I want to look at the last entry for each asset, if it is checked out I want to include this in the report.

Looking for some suggestions on how to do this.

[gemadan96]

It occurred to me it may be possible to use data macros to update a LastTransaction field in the Assets table when a new record is added to the TransactionDetails table for that asset.

Any suggestions on how to do that are appreciated.