>ORDER BY AcctInfo.ai_acprim cn_lname, cn_fname ; >>
>SELECT Client.cn_primary, Client.cn_fname, Client.cn_lname, ; > Acctinfo.ai_cnprim, ; > Acctinfo.ai_acprim, Acctinfo.ai_dateent, Acctinfo.ai_dateext, ; > Trans.tr_amt, Trans.tr_date, Trans.tr_acfrom, Assetc.ac_desc ; > FROM pf!client ; > INNER JOIN pf!acctinfo ; > ON Client.cn_primary = Acctinfo.ai_cnprim ; > INNER JOIN pf!assetc ; > ON Acctinfo.ai_acprim = Assetc.ac_primary ; > INNER JOIN pf!TRANS ; > ON Acctinfo.ai_cnprim = TRANS.tr_cnprim ; > AND Acctinfo.ai_acprim = TRANS.tr_acprim ; > WHERE ASCAN(laAcPrim,Acctinfo.ai_acprim) > 0 ; > AND (EMPTY(Acctinfo.ai_dateext) OR Acctinfo.ai_dateext >= DATE(2001,1,1)) ; > AND Trans.tr_type = 'T' ; > AND Trans.tr_date >= DATE(1995,1,1) ; > ORDER BY AcctInfo.ai_acprim, YEAR(tr_date), MONTH(tr_date), cn_lname, cn_fname ; > INTO CURSOR curs1 >You can not use VFP functions in order by clause. You will have to add these fields to your select statement and sort by them.