>The query designer generates a SQL command. The TOP clause is part of the SQL Select command syntax.
>
>The following is a simple example of its use:
>
>select * TOP 10 ;
> from MyTable ;
> into cursor MyCursor
>
>OR
>
>select * TOP 10 PERCENT;
> from MyTable ;
> into cursor MyCursor
>
>If you select Query->View SQL from the FoxPro menu when the query designer is running then you can see exactly the effect the interface objects/selections have on the code.
You need a GROUP BY in order to use the TOP on a SQL SELECT.