A kind of excels "For Each"

[filo666]

Hi, I want to make a report of the sales on the month, so I have this:
Date Sale
12/08/05 2345
12/08/05 6667
12/08/05 1212
13/08/05 4544
13/08/05 444
13/08/05 4598
14/08/05 8789
14/08/05 5656
14/08/05 898
AND SO ON
and I whant this:
12/08/05 10215
13/08/05 7980
14/08/05 17893
And so on until the ende of the month where I want to put the Grand Total

How to accomplish what I want???
TIA

 

[Duane Hookom]

Try a totals query.

SELECT [Date], Sum([Sale]) as DailySum
FROM tblNoNameProvided
WHERE Month([Date]) = 8 AND Year([Date])=2005
GROUP BY [Date];

Put this in a report with totals in the report footer.

 

[filo666]

Tanks, it was usefull.

What about the same but instead of the date I want the bill number totals

bill sale
122 1234
122 585
122 459
123 458
123 5858
and so on ??????????

Tia

Try a totals query.

SELECT [Date], Sum([Sale]) as DailySum
FROM tblNoNameProvided
WHERE Month([Date]) = 8 AND Year([Date])=2005
GROUP BY [Date];

Put this in a report with totals in the report footer.


--
Duane Hookom
MS Access MVP
--

Hi, I want to make a report of the sales on the month, so I have this:
Date Sale
12/08/05 2345
12/08/05 6667
12/08/05 1212
13/08/05 4544
13/08/05 444
13/08/05 4598
14/08/05 8789
14/08/05 5656
14/08/05 898
AND SO ON
and I whant this:
12/08/05 10215
13/08/05 7980
14/08/05 17893
And so on until the ende of the month where I want to put the Grand Total

How to accomplish what I want???
TIA

 

[Duane Hookom]

Seems to me, you should be able to apply my example to any combination of
fields.

--
Duane Hookom
MS Access MVP

Tanks, it was usefull.

What about the same but instead of the date I want the bill number totals

bill sale
122 1234
122 585
122 459
123 458
123 5858
and so on ??????????

Tia

Try a totals query.

SELECT [Date], Sum([Sale]) as DailySum
FROM tblNoNameProvided
WHERE Month([Date]) = 8 AND Year([Date])=2005
GROUP BY [Date];

Put this in a report with totals in the report footer.


--
Duane Hookom
MS Access MVP
--

Hi, I want to make a report of the sales on the month, so I have this:
Date Sale
12/08/05 2345
12/08/05 6667
12/08/05 1212
13/08/05 4544
13/08/05 444
13/08/05 4598
14/08/05 8789
14/08/05 5656
14/08/05 898
AND SO ON
and I whant this:
12/08/05 10215
13/08/05 7980
14/08/05 17893
And so on until the ende of the month where I want to put the Grand
Total

How to accomplish what I want???
TIA