>>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.

Thanks! Why is that?

Tommy