Query Total

[ShostyFan]

I have a table that tracks a physical inventory done once a year, ProductCode, Qty, Date.


The date field tracks the day, month, year, and time.

I am struggling to create a query that sums each unique ProductCode by the date.

I started by changing the date format in the query to: MaxDateCount: Max(DateValue([DateCounted]))
This query works as desired.

My struggle is to get Qty sum of only the MaxDateCount.

From here I am in the sad state of guessing and checking with no positive results.

thanks

[pbaldy]

Is this appropriate?

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

[ShostyFan]

Is this appropriate?

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

Worked Perfectly, a million thanks!

[pbaldy]

Happy to help!