Value of latest date

[v!ctor]

Hello


I am new in access and I am facing some difficalties

I have a table (records purchases) with items (code), date of purchase and value.
I am trying to create a query so to have the most recent value depending the date in each item.

Can anyone please help

[pbaldy]

Is this what you're looking for?

http://www.baldyweb.com/LastValue.htm

[v!ctor]

Yes I think its like this, but I dont now how to create it.

I have already have create a query that I have grouped the item and I have set "MAX' the date. But I dont know what creteria to put in value

[pbaldy]

Based on what you've said so far, I don't see the need for a criteria.