×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

# how to sum 2 collumns

## how to sum 2 collumns

(OP)
Dear all,

I am pretty new to Access so this might be some of those questions where the answer is really easy. for me it's still a problem i can't figure out.

My question is how to sum up for example costs from 2 different collumns.

example:

Toolingcosts = $200.000 Piece price =$230
Total price  = is it possible to do something with the properties that it automatically sums up collumn toolingcosts and piece price so that the total costs (toolingcosts + piece price) will appear in the Total price collumn?

Kind regards,

D.T

### RE: how to sum 2 collumns

Hi,

#### Quote:

Total price collumn
It is not best and accepted database practice to store aggregations or calculated values.

These kinds of values are normally calculated in a query...

#### CODE

Select
toolingcosts
, piece price
, toolingcosts + piece price As 'Total Price'

From [YourTable]
I would even question a field like toolingcosts as it seems it might be an aggregation of some lower level detail.

Skip,

Just traded in my old subtlety...
for a NUANCE!

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Close Box

# Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!