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.

Thanks in advance!

best regards
EuroCasaCarAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor 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
 
Rey Obrero (Capricorn1)Commented:
you can that by using a total query

select  propertyName,Sum(m2)
from tablex
group by propertyName
0
 
Helen FeddemaCommented:
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
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
EuroCasaCarAuthor Commented:
@Helen_Feddema

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


0
 
Rey Obrero (Capricorn1)Commented:
EuroCasaCar,

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

Thank you for your answers.
I know but in this case we need it.

0
 
Rey Obrero (Capricorn1)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
 
EuroCasaCarAuthor Commented:
Later today I will post a sample.
Thank you for your help.
0
 
EuroCasaCarAuthor 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.

Thanks in advance!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.