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         && I don't want this record
>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