sum total between two dates

  • Thread starter Thread starter Troy
  • Start date Start date
T

Troy

Hello, I am trying to calculate a total between two dates and use this query
to append to a table. I have worn the pages out in my access books looking
for a solution. What is the proper parameters to use?

TIA

Troy
 
Please take a little time to type some sample records and desired results.
Total what?
Where to display?
With other information or just the total?
 
Table: Maintenance
Date | Vendor | Invoice # | Description | Total
1/15/2004 Axiohm 822011 Validator $989.00
2/12/2004 CDW NC5467 printer kit $315.00
3/15/2004 Dell 7988900 SCSI cards $1000.00
5/19/2004 CDW AS2344 various tools $215.00

That is a small example of the table. Now I would like to create a query
that would use "between two dates" and give me a sum of them. Basically why
I need this is for IT committee meetings and they vary on what day of the
month they are held. I have another table I would like to list the
subtotals in between these meetings, like below. ( the query would need to
append the table below.

February 5, 2004 $ 4,161.95
March 18, 2004 $ 900.24
May 5, 2004 $ 729.00
June 23, 2004 $ 2,653.01
August 5, 2004 $ 5,498.56


I hope this is enough explanation. If not let me know and I will try again.
Thanks!
 
How do the values from your first results have anything to do with results
from the second table/query? ie: Where did 900.24 come from? If you want
totals from between meeting dates, then the first place to start is to
create a table of meeting dates. Do you have a table like this?
 
Back
Top