>I have one group by command in Select statement while taking salesperson report.
>Kindly let me know how to handle this.
>
>Thanks/Regards - Saif
Read Set Enginebehavior in Help. Also note that you should AVOID setting this to other than 90, since you can end up with WRONG data. There were problems with the SQL engine in VFP7 and VFP8 which were fixed in VFP9. But to help us programmers they added Set Enginebehavior so that we could get our programs up and running, and deal with changing the select statements later.