SQL command convert into access

[eraydin_genc@yahoo.com]

select Saler, Model, Price, DDate
from DB_Table where DDate in
(select max(DDate) from DB_Table where Valid = 'ok' group by Saler, Model)



How can I make it work in ms access 2007?
I am trying to get valid (ok) price for Saler-Model group at max date.

[pbaldy]

Is this what you're trying to do?

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

[orange]

Try this (untested)

select Saler
, Model
,Price
from DB_Table
where
DDate =(select max(DDate)
from DB_Table
where Valid = "ok")
group by Saler, Model,Price

[eraydin_genc@yahoo.com]

Is this what you're trying to do?

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

Thank you for the reply,

It is a 2 layer solution with 2 query.
I want to make it in a single query.

[pbaldy]

Not sure why, but:

SELECT VehicleMiles.*
FROM VehicleMiles INNER JOIN [SELECT Max([VehicleMiles].[DorDate]) AS MaxDate, [VehicleMiles].[CarNum]
FROM VehicleMiles
GROUP BY [VehicleMiles].[CarNum]]. AS qryMaxDates ON (VehicleMiles.CarNum = qryMaxDates.CarNum) AND (VehicleMiles.DorDate = qryMaxDates.MaxDate);