I have a table with three columns (ID, ProductIDNo, DateReceived).
ProductIDNo field has duplicates with different DateReceived values.
I want to filter it to include all records only for Max DateReceived for that record.
Is this possible?
I posted a similar, but opposite, question yesterday (thank you for the help, Rey)
Below selects all of the records that are less than the Max DateReceived :
FROM CPEQUP T
(SELECT CPEQUP.ProductIDNo, Max(CPEQUP.DateReceived) AS MaxOfDateReceived
GROUP BY CPEQUP.ProductIDNo) As T1
Where T1.MaxOfDateReceived Is Null
8/22/2022 - Mon
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat