# Is it possible to sum from multiple fields in calcutalted Filed?

Is it possible to sum from multiple fields in calcutalted Filed?
I have a table with square value (m2). See figure:

-------------------------------------------------- -----------------------------
PropertyID propertyName m2
-------------------------------------------------- -----------------------------
1           castle           200
2           tent              120
3           castle          310
4           yard             540
-------------------------------------------------- -----------------------------

I want to sum castle (200 + 310 = 510) in a Calculated Field. Is it possible or do I make a query for it. In that case, I am grateful for an example.

best regards
###### Who is Participating?

Commented:
or you can use a crosstab query

TRANSFORM Sum(TableX.m2) AS SumOfm2
SELECT TableX.propertyName
FROM TableX
GROUP BY TableX.propertyName
PIVOT TableX.propertyName;
0

Commented:
you can that by using a total query

select  propertyName,Sum(m2)
from tablex
group by propertyName
0

Commented:
This can also be done with a PivotTable.  Where do you want to see the results of this calculation?  A form, a report, a chart?
0

Author Commented:
@Helen_Feddema

Thank you. I want to store the value in a table. The same table (tablex).

0

Commented:
EuroCasaCar,

it is not advisable to store calculated data in the table. you can always derived the accurate information using a query.
0

Author Commented:
@capricorn1

I know but in this case we need it.

0

Commented:
ok, post sample values with field names that show the information with the calculated value after you run an update query or make table query.

0

Author Commented:
Later today I will post a sample.
0

Author Commented:

I have a table with a number of fields. Among other fields, "square", "TotalSale2011" and "Rent2011".

I would by a new field (Calculated field) make a calculation:
sum (TotalSales2011) / square meter.

So get the sum of TotalSales2011 (all items) divided by the square of the unique item. Is it possible to do so via Calculated Field.