Hi,
In an excel sheet I have data as shown below:
Code:
Code No. BillDate Cost
A00001 14/05/05 435.00
A00002 14/05/05 40.00
A00003 16/05/05 20.00
A00004 14/05/05 435.00
A00005 12/05/05 945.00
A00006 12/05/05 789.00
There are several number of records.
There is an userform, on which user enters two dates & on click of a button, it should display the Sum of cost between these 2 dates:
Suppose user enters 13/05/05 & 14/05/05, it should display 910.00
Please help me to get this using ODBC or something similar.
Thanks.