sum if max date

[ShostyFan]

I have a table that stores a physical inventory count. I am struggling to write a query that will sum the quantity of just the records with the most recent date. For example:
If this is the input, Product, Date, and Qty.
product1 6/1/2015 1
product1 6/1/2015 1
product1 5/1/2015 1



I want a query to sum the qty of only the MaxDate, so in the example I gave, the total Qty would be 2.
Currently I can output the max date just fine, but when I sum the Qty I keep getting 3 as my output.

Thanks

[ranman256]

In a query, Q1, get max of date:
select Max([date]) as MaxOfDate from table.

In another query, Q2, use Q1 to limit the list of Q2...
SELECT * FROM table INNER JOIN qsMaxDate ON table.DAte = qsMaxDate.MaxOfDAte

[ShostyFan]

Thanks for the post, but I am still having an issue.
a proposal of the issue is that in Q1, get max of date, it only returns 1 instance of the product even if it was counted two times on the same day.
I checked all levels of the date format field and the Time is not being captured. The date field is set to Date/Time as a dataType but then the format is Short Date.
here is my Q1:

SELECT [Tble Inventory].ProductCode, Max([Tble Inventory].dateCounted) AS MaxOfDate
FROM [Tble Inventory]
GROUP BY [Tble Inventory].ProductCode;

Q2:
SELECT *
FROM [Tble Inventory] INNER JOIN Qry_MaxDateInventory ON [tble Inventory].DateCounted = qry_MaxDateInventory.MaxOfDate;



Thanks.

[ShostyFan]

Does anybody have a suggestion on how to handle this issue? It is a real thorn in my side.
Thanks.