>>>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. :-)
Thanks! < sheepish g >