I have two tables and I need to show incoming amount from each against the range of days selected by the user. I also need to total the two amounts where the dates are the same. My database is access.
The result I want to show is eg
Date amountOne amountTwo Total
02/01 1000 1000
02/02 500 1000 1500
and so on
Thank you very much for your time and consideration.
September 21, 2005 10:06 PM
September 23, 2005 5:24 PM