I need to retrieve a result set that contains the last dated record for an item for each of type O, Q and I records. I'm using Access and a SQL response or Access Query would be acceptable.
Consider the table has an ID, Date, Item Type and Price fields. The result set must contain the most recent dated record for a specified item for records type O, Q and I with the Amount field of each.
The query is used to return the last price paid for an item amount existing Order, Quote and Invoices. (i.e. is can return up to 3 records or as few as none)