VFP Query Solution

TheMSsForum.com: The Microsoft Software Forum

Dear All

I have one problem, data and output I want as per below
description. What query should I need to write ?

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

CODE DATE QTY TIME

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


i.e. QTY and TIME OF MAX DATE

Thanks in Advance
Top