Having the value at max date

[eraydin_genc@yahoo.com]

Hello Friends,

I need to create a result table with the valid (ok) prices for each car and each saler on max date.
I need SQL comand to use in Ms Access 2007
Please look at below to understand me better. Datas in DB and Expected Result

Datas in DB
Model Saler Date Price Valid
Car1 Saler3 20111205 15000 ok
Car1 Saler3 20111204 14950 ok
Car1 Saler2 20111103 14800 ok


Car1 Saler2 20111009 15500 ok
Car1 Saler2 20111009 17000 Not
Car1 Saler4 20111218 14900 Nok
Car1 Saler4 20111213 14500 ok
Car1 Saler4 20100505 15000 ok
Car1 Saler4 20110916 14750 ok
Car2 Saler1 20111105 15000 ok
Car2 Saler1 20111206 14950 ok
Car2 Saler1 20111008 14800 ok
Car2 Saler1 20110917 15500 ok
Car2 Saler3 20111206 17000 Nok
Car2 Saler3 20111115 15500 ok

Expected Result
Model Saler Date Price Valid
Car1 Saler3 20111205 15000 ok
Car1 Saler2 20111103 14800 ok
Car1 Saler4 20111213 14500 ok
Car2 Saler1 20111206 14950 ok
Car2 Saler3 20111115 15500 ok

[pbaldy]

Answered here I think:

https://www.accessforums.net/access/...ess-19986.html

[eraydin_genc@yahoo.com]

Hello Friends,

I need to create a result table with the valid (ok) prices for each car and each saler on max date.
I need SQL comand to use in Ms Access 2007
Please look at below to understand me better. Datas in DB and Expected Result

Datas in DB
Model Saler Date Price Valid
Car1 Saler3 20111205 15000 ok
Car1 Saler3 20111204 14950 ok
Car1 Saler2 20111103 14800 ok
Car1 Saler2 20111009 15500 ok
Car1 Saler2 20111009 17000 Not
Car1 Saler4 20111218 14900 Nok
Car1 Saler4 20111213 14500 ok
Car1 Saler4 20100505 15000 ok
Car1 Saler4 20110916 14750 ok
Car2 Saler1 20111105 15000 ok
Car2 Saler1 20111206 14950 ok
Car2 Saler1 20111008 14800 ok
Car2 Saler1 20110917 15500 ok
Car2 Saler3 20111206 17000 Nok
Car2 Saler3 20111115 15500 ok

Expected Result
Model Saler Date Price Valid
Car1 Saler3 20111205 15000 ok
Car1 Saler2 20111103 14800 ok
Car1 Saler4 20111213 14500 ok
Car2 Saler1 20111206 14950 ok
Car2 Saler3 20111115 15500 ok

Is there anybody who can get this result from these datas using a single query?

[pbaldy]

Please don't post the same questions twice:

https://www.accessforums.net/access/...ess-19986.html