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