how to sum 2 collumns

[DTLe]

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

 

[SkipVought]

Hi,

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

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

From [YourTable]

I would even question a field like toolingcost[red]s[/red] as it seems it might be an aggregation of some lower level detail.



Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]