Querry not working? Tring to use max date to pull only newest records.

[pendlet]

I am trying to pull records that have two criteria <=[ReOrderLevel] based on the newest date the item was inventoried.



I get an error every time I run this. Products will be listed numerous times in the inventory table based on when they were last inventoried. It should pull out the newest recorded of each item but only if it’s [TotalQTYinventoried] field is <= [reorderlevel]. The query should not list each product more than once.

[June7]

Totals queries don't really show the record with raw source data, they return an aggregate calculation of numerous records.
Instead of Group By under TotalQtyinStock, try WHERE. The result should be ProductName and InventoryDate fields showing.
Showing the entire record with the TotalQtyinStock values will require subqueries to return the record where InventoryDate is equal to the Max(InventoryDate).

[pendlet]

Man that makes total sense. I dont know why i did not catch that myslef. It works just like it is suposed to now thanks.