We would need to know your criteria you are using to eliminate the record you do not want in the results set. Posting the SQL you used in VFP7 might also help.
>Hi,
>I have the following data
>
>
>AW01 16.00 01/01/2004
>AW01 12.00 01/01/2004
>AW02 13.00 02/01/2004
>AW03 17.00 03/01/2004
>
>
>and I want the result look like this
>
>AW01 12.00 01/01/2004
>AW02 13.00 02/01/2004
>AW03 17.00 03/01/2004
>
>
>How the SQL look like? I tried to use GROUP BY 1,2 clause, it works VFP7 but not VFP8. How to modify the SQL to get the same thing in VFP8 beside of using SET ENGINEBEHAVOUR statement?
>
>Thank you
Mark McCasland
Midlothian, TX USA