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!