Filter table by name with the latest price

[Sogood]

how can i filter a table "date , item name , price"

by only show an item name per line with latest price ?

 

[dallr]

Try:

SELECT T1.*
FROM YourTable T1 INNER JOIN 
   (SELECT Max([Date]) As MaxDate, Item FROM YourTable GROUP BY Item) T2. 
  ON (T1.Item = T2.Item AND T1.Date = T2.MaxDate)

PS: Please note that the word date is a reserved word in Access

Dane

 

[Sogood]

thanks ~ it works

 

[dallr]

NO problem.

Dallr