Selecting items with most recent date in subform

[doctorswamp]

Hi

In a subform that logs production of items in batches of different types, and their batch dates, I'd like to pick out the most recent price per item. The subform has source Batches and links via ItemID to the main form.

For a particular ItemID the subform data could look like this

Date Qty BatchType Price
1/6/06 5 S 1.25
1/12/06 7 S 1.35
6/12/06 8 P 1.20

and I'd like to pick out, for Type S, that the latest price is 1.35 with Date 1/12/06. Prices can go down as well as up.

 

[Pampers]

You could use the Dmax-function to this.

Pampers
Keeping it simple can be complicated