Cumulative Toals In Reports

[DWright]

I want to run a Cumulative Total In A Weekly Var. report. My Control Sources
Are:
Weekly Var. Cumulative Sales Cumulative Purchases Cumulative Var.
Percent Markup. I am not sure how to do it. Any help would be greatly
appreciated.

Thank You In Advance

 

[Duane Hookom]

How about type about 10 records and the desire results into a reply?

 

[Fons Ponsioen]

Can you be bit more specific, Is this a table you are
detailing below or is this allready the result of a query.
Do I understand that the variables are:
WkVar, CumSales,CumPurchas,CumVar, and PercMkup?
Now what type of variables are these, all numbers?
which variables to you want to sum (cumulative total) in a
report. How do you wish to group them, just by week
number? if so you will need a date.
Maybe I do not understand the meaning of the "control
sources".
Give me something to work with.
Fons

 

[Duane Hookom]

I asked for 10 records and the desired display in the report and I am not
sure what you provided.
To get totals of any field in a report just add a text box in a group or
report footer with a control source like:
=Sum([Sales])

 

[DWright]

Duane: Following are the ten records you requested.
WeeklySalesID SalesCategoryID Week Ending
Date ActualWeeklySales ActualWeeklyPurchases
ID
Cate. Date ActSales ActPurch BenInv
EndingInv.
1 Deli 4/7/04 $1,500.00 $750.00 $1,400.00 $500.00 0
2 Bakery 4/7/04 $2,500.00 $1,500.00 $500.00 $1,000.00 0
3 Deli 4/14/04 $2,500.00 $1,500.00 $0.00 $500.00 0
4 Grocery 4/14/04 $9,500.00 $5,500.00 $5,000.00 $4,500.00 0
5 Grocery 3/31/04 $8,500.00 $3,500.00 $4,500.00 $3,555.00 0
6 Deli 4/24/04 $3,500.00 $2,500.00 $0.00 $1,500.00 0
7 Grocery 6/4/04 $2,500.00 $2,000.00 $0.00 $0.00 0
8 Deli 6/30/04 $1,500.00 $800.00 $0.00 $0.00 0
9 Bakery 6/30/04 $1,200.00 $600.00 $0.00 $0.00 0
10 Bakery 8/14/04 $1,600.00 $1,200.00 $0.00 $0.00 0
I know how to get a total (sum) of any field in a report. My Barrier is that
I need to have a cumualtive running total of sales, purchases, etc. in my
reports.
Ex: Cumulative Report - Deli Sales First Week Sales were 1500.00, Second
Week sales were 1700.00, third week sales were 1500.00. In the Cumulative
Report it would show Cumulative Sales of 1500.00, the second week it would
show cumulative sales of 3200.00, and the tird week the Cumulative total
would show 4700.00 and so on. This cumulative running total would be the same
for all the various categories. I Hope this clarifies it a little more for
you.
Thank You
Warren

I asked for 10 records and the desired display in the report and I am not
sure what you provided.
To get totals of any field in a report just add a text box in a group or
report footer with a control source like:
=Sum([Sales])


--
Duane Hookom
MS Access MVP

Weekly Cumulative Report
Week Ending Date
Sales Category
Weekly Var. Cum. Sales Cum. Purch. Cum. Var. Pe
rMarkup
3/31/04 Grocery $2,875.00 $8,500.00 $3,500.00 $2,875.00 58.82%

4/7/04 Deli $0.00 $1,500.00 $750.00 $0.00 50.00%
Bakery $125.00 $2,500.00 $1,500.00 $125.00 40.00%
4/14/04
Deli ($250.00) $2,500.00 $1,500.00 ($250.00) 40.00%
Grocery $1,625.00 $9,500.00 $5,500.00 $1,625.00 42.11%
4/24/04
Deli ($750.00) $3,500.00 $2,500.00 ($750.00) 28.57%
6/4/04
Grocery ($125.00) $2,500.00 $2,000.00 ($125.00) 20.00%
6/30/04
Deli ($50.00) $1,500.00 $800.00 ($50.00) 46.67%
Bakery $180.00 $1,200.00 $600.00 $180.00 50.00%

Duane, What I need is a Cumulative Total For Eacgh sales Category Wich Will
Carry Through For The Whole Year And Also Show A Cumulative up to and Through
a particular Date Range. thank You

 

[Duane Hookom]

Have you tried setting the Running Sum property of the text boxes to Over
Group or Over All?

--
Duane Hookom
MS Access MVP

Duane: Following are the ten records you requested.
WeeklySalesID SalesCategoryID Week Ending
Date ActualWeeklySales ActualWeeklyPurchases
ID
Cate. Date ActSales ActPurch BenInv
EndingInv.
1 Deli 4/7/04 $1,500.00 $750.00 $1,400.00 $500.00 0
2 Bakery 4/7/04 $2,500.00 $1,500.00 $500.00 $1,000.00 0
3 Deli 4/14/04 $2,500.00 $1,500.00 $0.00 $500.00 0
4 Grocery 4/14/04 $9,500.00 $5,500.00 $5,000.00 $4,500.00 0
5 Grocery 3/31/04 $8,500.00 $3,500.00 $4,500.00 $3,555.00 0
6 Deli 4/24/04 $3,500.00 $2,500.00 $0.00 $1,500.00 0
7 Grocery 6/4/04 $2,500.00 $2,000.00 $0.00 $0.00 0
8 Deli 6/30/04 $1,500.00 $800.00 $0.00 $0.00 0
9 Bakery 6/30/04 $1,200.00 $600.00 $0.00 $0.00 0
10 Bakery 8/14/04 $1,600.00 $1,200.00 $0.00 $0.00 0
I know how to get a total (sum) of any field in a report. My Barrier is that
I need to have a cumualtive running total of sales, purchases, etc. in my
reports.
Ex: Cumulative Report - Deli Sales First Week Sales were 1500.00, Second
Week sales were 1700.00, third week sales were 1500.00. In the Cumulative
Report it would show Cumulative Sales of 1500.00, the second week it would
show cumulative sales of 3200.00, and the tird week the Cumulative total
would show 4700.00 and so on. This cumulative running total would be the same
for all the various categories. I Hope this clarifies it a little more for
you.
Thank You
Warren

I asked for 10 records and the desired display in the report and I am not
sure what you provided.
To get totals of any field in a report just add a text box in a group or
report footer with a control source like:
=Sum([Sales])


--
Duane Hookom
MS Access MVP

Weekly Cumulative Report
Week Ending Date
Sales Category
Weekly Var. Cum. Sales Cum. Purch. Cum.

Var.
Pe

rMarkup
3/31/04 Grocery $2,875.00 $8,500.00 $3,500.00 $2,875.00 58.82%

4/7/04 Deli $0.00 $1,500.00 $750.00 $0.00 50.00%
Bakery $125.00 $2,500.00 $1,500.00 $125.00 40.00%
4/14/04
Deli ($250.00) $2,500.00 $1,500.00 ($250.00) 40.00%
Grocery $1,625.00 $9,500.00 $5,500.00 $1,625.00 42.11%
4/24/04
Deli ($750.00) $3,500.00 $2,500.00 ($750.00) 28.57%
6/4/04
Grocery ($125.00) $2,500.00 $2,000.00 ($125.00) 20.00%
6/30/04
Deli ($50.00) $1,500.00 $800.00 ($50.00) 46.67%
Bakery $180.00 $1,200.00 $600.00 $180.00 50.00%

Duane, What I need is a Cumulative Total For Eacgh sales Category Wich Will
Carry Through For The Whole Year And Also Show A Cumulative up to and Through
a particular Date Range. thank You
:

How about type about 10 records and the desire results into a reply?

--
Duane Hookom
MS Access MVP


I want to run a Cumulative Total In A Weekly Var. report. My Control
Sources
Are:
Weekly Var. Cumulative Sales Cumulative Purchases Cumulative Var.
Percent Markup. I am not sure how to do it. Any help would be greatly
appreciated.

Thank You In Advance

 

[DWright]

Duane:
Taht Seemed To Do The Trick. Its Those Little Things That Slip Your Mind
Went Trying To Do Something. I feel I was Trying To Make It more difficult
than it was.
Thank You Again.

Have you tried setting the Running Sum property of the text boxes to Over
Group or Over All?

--
Duane Hookom
MS Access MVP

Duane: Following are the ten records you requested.
WeeklySalesID SalesCategoryID Week Ending
Date ActualWeeklySales ActualWeeklyPurchases
ID
Cate. Date ActSales ActPurch BenInv
EndingInv.
1 Deli 4/7/04 $1,500.00 $750.00 $1,400.00 $500.00 0
2 Bakery 4/7/04 $2,500.00 $1,500.00 $500.00 $1,000.00 0
3 Deli 4/14/04 $2,500.00 $1,500.00 $0.00 $500.00 0
4 Grocery 4/14/04 $9,500.00 $5,500.00 $5,000.00 $4,500.00 0
5 Grocery 3/31/04 $8,500.00 $3,500.00 $4,500.00 $3,555.00 0
6 Deli 4/24/04 $3,500.00 $2,500.00 $0.00 $1,500.00 0
7 Grocery 6/4/04 $2,500.00 $2,000.00 $0.00 $0.00 0
8 Deli 6/30/04 $1,500.00 $800.00 $0.00 $0.00 0
9 Bakery 6/30/04 $1,200.00 $600.00 $0.00 $0.00 0
10 Bakery 8/14/04 $1,600.00 $1,200.00 $0.00 $0.00 0
I know how to get a total (sum) of any field in a report. My Barrier is that
I need to have a cumualtive running total of sales, purchases, etc. in my
reports.
Ex: Cumulative Report - Deli Sales First Week Sales were 1500.00, Second
Week sales were 1700.00, third week sales were 1500.00. In the Cumulative
Report it would show Cumulative Sales of 1500.00, the second week it would
show cumulative sales of 3200.00, and the tird week the Cumulative total
would show 4700.00 and so on. This cumulative running total would be the same
for all the various categories. I Hope this clarifies it a little more for
you.
Thank You
Warren

I asked for 10 records and the desired display in the report and I am not
sure what you provided.
To get totals of any field in a report just add a text box in a group or
report footer with a control source like:
=Sum([Sales])


--
Duane Hookom
MS Access MVP


Weekly Cumulative Report
Week Ending Date
Sales Category
Weekly Var. Cum. Sales Cum. Purch. Cum. Var.
Pe
rMarkup
3/31/04 Grocery $2,875.00 $8,500.00 $3,500.00 $2,875.00 58.82%

4/7/04 Deli $0.00 $1,500.00 $750.00 $0.00 50.00%
Bakery $125.00 $2,500.00 $1,500.00 $125.00 40.00%
4/14/04
Deli ($250.00) $2,500.00 $1,500.00 ($250.00) 40.00%
Grocery $1,625.00 $9,500.00 $5,500.00 $1,625.00 42.11%
4/24/04
Deli ($750.00) $3,500.00 $2,500.00 ($750.00) 28.57%
6/4/04
Grocery ($125.00) $2,500.00 $2,000.00 ($125.00) 20.00%
6/30/04
Deli ($50.00) $1,500.00 $800.00 ($50.00) 46.67%
Bakery $180.00 $1,200.00 $600.00 $180.00 50.00%

Duane, What I need is a Cumulative Total For Eacgh sales Category Wich
Will
Carry Through For The Whole Year And Also Show A Cumulative up to and
Through
a particular Date Range. thank You
:

How about type about 10 records and the desire results into a reply?

--
Duane Hookom
MS Access MVP


I want to run a Cumulative Total In A Weekly Var. report. My Control
Sources
Are:
Weekly Var. Cumulative Sales Cumulative Purchases Cumulative Var.
Percent Markup. I am not sure how to do it. Any help would be greatly
appreciated.

Thank You In Advance