Queries totals problem (1 Viewer)

[bacardi451]

Hi,
I have a form that has two field that have sale amounts on them. My employee puts the sale amount in every day after the day is over. I would like to make a querie so that i can get the total sales amount from let say three days or even a week. I have tried everything but no luck.
Thank you in advance
I am pretty new at this so please bare with me.
Thank you
Al

 

[Gootz11]

if you have a date field enter this in the criteria
>=[Start Date] and <=[End Date] when you run the query it will ask you for a parameter. you can choose any time period you want. if you want to know the day of the week use:
Day:format([date],"dddd") in a new column, when you run the query it will return the day of the week next to the date.

 

[bacardi451]

Gootz11,
Thanks for the information, but How can I get the added totals. If I do a querie of let say 07/28/02, 07/29/02 and 07/30/02 I need to know the grand total for these three days. in other words How do I get it to add all three of them and give me one sum.
Thank you in advance
Al

 

[Gootz11]

I would run a query of that query that takes out the date and sums the total. emxpl:
que1: date Total (datasheet view)
7/28/02 350
7/29/02 300
7/30/02 400

Query 2 will run of query 1 but will only include the total colums
Emxp:

Que2: Total (Design view)
Sum

Que2: Sumoftotal (datasheet view)
1050

I hope that helps, I wasn't really sure if that's what your trying to do
good luck