Accumulative total in Form

[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?

 

[John Vinson]

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?

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

 

[Dorothy]

-----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?

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

 

[John Vinson]

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