adding up fields in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

H

I hope somebody can help me before i completely go insane

I am writing a query using the design view. I have several 8 fields eg, price 1, price 2, price 3, price 5 etc etc. What i would like to be able to do is add up each of these fields to make up one value eg, price 1 + price 2 + price 3 = £400.00

Can anybody tell me how i can do it

Thanks in advance for your help

Carol
 
Carol, it's just as you describe. In the grid at the bottom of the design
view, go to the first available column on the right, click in the criteria
row (top row), and type:

Total:[price1]+[price2] etc.

Then press Enter. (You can give your formula any name; I'm just using
"Total" as an example.) Right-click your formula and select Properties.
Format as Currency. Run the query.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

carol m said:
Hi

I hope somebody can help me before i completely go insane!

I am writing a query using the design view. I have several 8 fields eg,
Click to expand...
price 1, price 2, price 3, price 5 etc etc. What i would like to be able to
do is add up each of these fields to make up one value eg, price 1 + price 2
+ price 3 = £400.00.
 
Carol, it's just as you describe. In the query design view, go to the first
available column on the right in the grid, click in the Criteria row (the
top row), and type:

Total:[price1]+[price2] etc.

Then press Enter. "Total" is the name of your calculated field (you can use
any name you want). The colon is a required separator. Enclose field names
in square brackets [].

Right-click your calculation and select Properties. Set the format to
Currency, then close the Properties box. Run the query.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

carol m said:
Hi

I hope somebody can help me before i completely go insane!

I am writing a query using the design view. I have several 8 fields eg,
Click to expand...
price 1, price 2, price 3, price 5 etc etc. What i would like to be able to
do is add up each of these fields to make up one value eg, price 1 + price 2
+ price 3 = £400.00.
 
carol m said:
Hi

I hope somebody can help me before i completely go insane!

I am writing a query using the design view. I have several 8 fields eg,
Click to expand...
price 1, price 2, price 3, price 5 etc etc. What i would like to be able to
do is add up each of these fields to make up one value eg, price 1 + price 2
+ price 3 = £400.00.
Can anybody tell me how i can do it.
Click to expand...
Put you cursor in the field area of an an empty column. Press the wand
button on the toolbar, this should bring up a query builder. Type in
TotalPrice: [price1] + [price2] + etc
HTH
Marc
 
Back
Top