DateTime specifications in Access queries have to be enclosed between sharp signs.
SELECT SUM(CashRecv) FROM QB_BillProcess WHERE CustID=1 and TranDate BETWEEN #10/01/2013# AND #10/07/2013#
This is explicitly stated here:
Criteria for Date/Time fields[
^]