adding fields in tables

[tbcwarrior]

hi all

i can do simple additions in access but i have been asked to calculate fields in different tables

all i need to do is

i have 2 tables in my database
Table 1:main_database
Table 2:Security 2_3

and i have in table 1 got 1 field called Estimated security value
and in table 2 i have 2 fields called Sec 2 estimated value and Sec 3 estimated value

all i need to do is add all of the fields together in query or field in a form

i have tried =([Estimated security value]+[Security 2 & 3]![Sec 2 estimated value])+[Security 2 & 3]![Sec 3 estimated value]

but i get '#name error

thanks in advance
chris

 

[ColinEssex]

Your field names are not the same as you desribed in your tables.

Try this in the query

[Estimated security]+[Estimated Security 2]+[Estimated security 3]


Col

 

[tbcwarrior]

no that command also brings up #name when i build expression in query

 

[tbcwarrior]

update

hi ill try and explain a bit better

i have 2 tables
Main_database_fields and Security_ 2_3

in Main_database_fields i have a field called
Estimated_security_value

and on Security_ 2_3 i have two fields called
Sec2_estimated_value
Sec3_estimated_value

i basically need to add the values in these fields together to get a total (ie
Estimated_security_value £25000
Sec2_estimated_value £30000
Sec3_estimated_value£12000
Total = £67000

i can do this within one table but cannot sem to do it across tables
how do i do this in a query or in a field on the form