>>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.
You mean ORDER BY. :-)
Erik Moore
Clientelligence