i have a access in MSO2000 which will get updated daily
a table named CAP_Payment is with the following contents
Rcptno, Rcptdt, Bacno, amount, Paymode, Bankcd, Docno, Docdt, Name, Mobileno, Bankname, type and few others not of much importance
i need to view the same daily in a excel sheet based on query 'from' 'to' date
this wil be helpful to find duplicate entries
and custom sum based on Type and Paymode (cash&cheque/DD)
thanks


jai