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.
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.
