SELECT * FROM table1 WHERE ;

[Vp]

Dear All

CODE DATE QTY TIME
A 02/02/2008 5 10:30
A 05/02/2008 1 11:30
A 06/02/2008 2 07:30

B 01/02/2008 4 09:30
B 03/02/2008 2 02:30
B 02/02/2008 1 12:30


OUTPUT
QTY OF MAX DATE

CODE DATE QTY TIME

A 06/02/2008 2 07:30
B 03/02/2008 2 02:30

how can i get this result ?

Thanx

[Peter Doering]

Re: SELECT * FROM table1 WHERE ;

Vp wrote:

CODE DATE QTY TIME
A 02/02/2008 5 10:30
A 05/02/2008 1 11:30
A 06/02/2008 2 07:30
>
B 01/02/2008 4 09:30
B 03/02/2008 2 02:30
B 02/02/2008 1 12:30
>
OUTPUT
QTY OF MAX DATE
>
CODE DATE QTY TIME
>
A 06/02/2008 2 07:30
B 03/02/2008 2 02:30
>
how can i get this result ?

SELECT T1.Code, T1.Date, T1.Qty, T1.Time
FROM Tab1 AS T1
WHERE T1.Date In
( SELECT Max([Date])
FROM Tab1 AS T2
WHERE T2.Code=T1.Code )

BTW, DATE is a reserved word, you should choose a different field name.

--
Peter Doering [MVP Access]