Calculated field using field from another table

[mikeymay]

I have a table (PropertyTypes) that holds a field labelled TotalRevealM which needs to be used in another table (Properties) as part of a calculation in a field labelled TotalRevealM2

Both tables have a field labelled TypeRef which is a unique ID of each record in the PropertyTypes table.

The calculated field in the Properties table should be
(PropertyTypes.TotalReveal - 10) * 0.15) + 2

I am pretty much new to Access and I'm sure this will be simple but until you know, it's not simple!


TIA

 

[Joe4]

Use a Query to link these two tables together. Then fields from both tables are available to you in your calculation.
You can find information on "creating queries between two tables in Access" with a simple Google search.
There are many articles/tutorials/videos on the topic.

 

[Micron]

Calculated table fields are something one should avoid most of the time (if not always).
Microsoft Access tips: Calculated Fields

 

[Joe4]

Calculated table fields are something one should avoid most of the time (if not always).
Microsoft Access tips: Calculated Fields

Micron, is it even possible to do a calculated field at the Table level, if the fields needed in the calculation are found in two different tables?
I know you often can (but probably shouldn't) if all fields needed in the calculation are in that one table, but is it even possible if they are in multiple tables?
Never tried it myself (never wanted to, for the aforementioned reasons!)

 

[Micron]

No, cannot calculate in a field between tables. Table field calculations are quite limited in terms of what expressions you can use. Maybe that's a good thing. I realize the OP wanted to do it across tables; I just thought I'd throw some mud on the whole idea, regardless of what fields where involved.

 

[mikeymay]

Thanks for all the advice!

I will have a good look at each point and find a way that waorks.