while select * from CustTrans where CustTrans.TransDate > fromDate && CustTrans.TransDate < toDate && ((CustID && CustTrans.CustID == CustID) || !CustID)