Accumulative total in Form

  • Thread starter Thread starter Dorothy
  • Start date Start date
D

Dorothy

I have a data entry form that includes the following:

Req# Item Qty Req CostPerUnit Description
1 Other 240 $25.00 Statewide Olympics
1 Other 2 $10.00 Exam
2 Meal(s) 70 $25.00 Dinners
2 Award(s) 67 $40.00 25-Year Gifts
2 Award(s) 44 $45.00 30-Year Gifts
2 Award(s) 22 $50.00 35 Year Service Gifts

The Req# is the field that links them between this Item
table and Request table. I'd like to see the accumulative
total of all cost for Req #1 (240 x 25)+ (2 x 10)= $6020
and the same for Req #2 and each request after that. How
do I go about doing this?
 
I have a data entry form that includes the following:

Req# Item Qty Req CostPerUnit Description
1 Other 240 $25.00 Statewide Olympics
1 Other 2 $10.00 Exam
2 Meal(s) 70 $25.00 Dinners
2 Award(s) 67 $40.00 25-Year Gifts
2 Award(s) 44 $45.00 30-Year Gifts
2 Award(s) 22 $50.00 35 Year Service Gifts

The Req# is the field that links them between this Item
table and Request table. I'd like to see the accumulative
total of all cost for Req #1 (240 x 25)+ (2 x 10)= $6020
and the same for Req #2 and each request after that. How
do I go about doing this?
Click to expand...

You could create a Totals query such as:

SELECT [Req#], Sum([Qty Req] * [CostPerUnit]) AS TotalCost
FROM yourtable
GROUP BY [Req#];

and base a Form on the query.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
-----Original Message-----
I have a data entry form that includes the following:

Req# Item Qty Req CostPerUnit Description
1 Other 240 $25.00 Statewide Olympics
1 Other 2 $10.00 Exam
2 Meal(s) 70 $25.00 Dinners
2 Award(s) 67 $40.00 25-Year Gifts
2 Award(s) 44 $45.00 30-Year Gifts
2 Award(s) 22 $50.00 35 Year Service Gifts

The Req# is the field that links them between this Item
table and Request table. I'd like to see the accumulative
total of all cost for Req #1 (240 x 25)+ (2 x 10)= $6020
and the same for Req #2 and each request after that. How
do I go about doing this?
Click to expand...

You could create a Totals query such as:

SELECT [Req#], Sum([Qty Req] * [CostPerUnit]) AS TotalCost
FROM yourtable
GROUP BY [Req#];

and base a Form on the query.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
.
Excellent. That worked - Thanks
Click to expand...
 
On Tue, 28 Sep 2004 13:16:44 -0700, "Dorothy"


Dorothy, for some reason I can't download your reply to my answer.
Please pardon the inconvenience and post it again.... thanks!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top