Achieving a grand total of five or more fields for a period of tim

[znibk]

Each month, I enter by date, a specific type of income, ie: sales, cash
donations, etc. Currently when I enter the desired time period, January 1
through January 31, 2008, I receive a total for each type of income for each
date. For example if I entered on 25 cash donations on Jan 25, 2008, it
totals only those donations for that day and does not include the donations I
received from January 1, 2008 until January 31, 2008.

Really hope this makes sense and someone can help me figure out what I
should be doing.

Thanks for all your help, k

 

[KARL DEWEY]

Post the SQL of your query for someone to fix it for you.
Open the query in design view, click on menu VIEW - SQL View, highlight all,
copy, paste in a post.