>Hi Gang....
>
>This code throws up a "SQL: Order By clause is invalid" error.
>
>

>SELECT * from regtrans ;
>	WHERE regtrans.trans_date >= Thisform.cntDates.txtFrom.Value AND ;
>		  regtrans.trans_date <= Thisform.cntDates.txtTo.Value ;
>	UNION ;
>SELECT * from tranhist ;
>	WHERE tranhist.trans_date >= Thisform.cntDates.txtFrom.Value AND ;
>		  tranhist.trans_date <= Thisform.cntDates.txtTo.Value ;
>	INTO CURSOR csrTotalTran ORDER BY trans_date, trans_time
>

>
>What is wrong?
>
>Thanks!

Union needs order by the field # (order by 5,6), not field name.