# Thread: Multiplying a sum

1. Registered User
Join Date
Oct 2003
Posts
2

## Unanswered: Multiplying a sum

Ok, ive worked out the sum of a table using the query wizard, how i want to multiply what i have got my 10%

how would i go about doing it?
heres the data

Book Value
1.00
95.00
40.00
199.00
55.00
69.00
24.00
20.00
54.00
82.00
48.00
35.00
24.00
1.00
28.00
76.00
43.00
33.00
15.00
35.00
23.00
25.00
16.00
20.00
14.00
50.00
75.00
36.00
142.00
36.00

then the total value is \$1414.00
so, how would i get a query to tell me 10% of that total

2. Join Date
Jun 2003
Location
USA
Posts
1,032

## Re: Multiplying a sum

Originally posted by raida
Ok, ive worked out the sum of a table using the query wizard, how i want to multiply what i have got my 10%

how would i go about doing it?
heres the data

Book Value
1.00
95.00
40.00
199.00
55.00
69.00
24.00
20.00
54.00
82.00
48.00
35.00
24.00
1.00
28.00
76.00
43.00
33.00
15.00
35.00
23.00
25.00
16.00
20.00
14.00
50.00
75.00
36.00
142.00
36.00

then the total value is \$1414.00
so, how would i get a query to tell me 10% of that total
I believe you'd create a new field in the query set for Expression and have the field be something like MyTotal10Percent: Round([MyTotal] * .1, 2)

3. Registered User
Join Date
Oct 2003
Posts
2
ah, can u give me the process of doing it, like where to go to make a new expression and stuff
and where to input ur answer

4. Join Date
Jun 2003
Location
USA
Posts
1,032
All within design mode of the query.

http://www.mvps.org/access/queries/index.html

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•