If a table stores price changes against an inventory item. Over time there may be many prices against this inventory item whether up or down in price. Lets say the date in the t01Price table is "AdjustDate" and there is a "Purchaseprice" field. I would like to set up a query that returns one row each which is the latest price on every single inventory item. I.e. if there is a 1000 records in the table but 80 inventory items, the query must return 80 records with the latest price.