"last" function in totals query

[WimDC]

Hello,

I'm trying to build (a rather simple) totals-query, but the "last" function doesn't give me the right values.
Suppose I have a database where the amount of products that were sold are stored per month. It's possible that some products are not sold in some months. (see the really dummy-database in attachment)

Now, I want the LAST REAL VALUE (= amount) for each product, no matter what month :

prod1 = 4
prod2 = 3
prod3 = 3

How can I do that, because the LAST-function gives me
prod1 = (empty)
prod2 = 3
prod3 = (empty)



Thanks for helping!

[JoeM]

I cannot download your database from my location.

What is "last" in relation to? A date field? If so, try "MAX" instead.

Also, you may need to do this in a two-step process, one to find the "MAX" date for each product, and then a second to link back to the original data source to get the amount associated with that product and date.