Total field on query

[Guest]

Hi,

I used the fomular below to sum the fields. I works fine. I need to add the
table name (Student) to this fomular. Please show me how. thanks. Chi

Total Score: Nz([Section 1 - Pain Intensity],0)+Nz([Section 2 - Personal
Care],0)+Nz([Section 3 - Lifting],0)+Nz([Section 4 - Walking],0)+Nz([Section
5 - Sitting],0)+Nz([Section 6 - Standing],0)+Nz([Section 7 -
Sleeping],0)+Nz([Section 8 - Social Life],0)+Nz([Section 9 -
Traveling],0)+Nz([Section 10 - Changing Degree of Pain],0)

 

[Diego Arbe]

Chi,

Just include the table name at the beginning of each field in brackets,
followed by an exclamation mark.

For example... instead of having [Section 1 - Pain Intensity]
replace it for [Student]![Section 1 - Pain Intensity]

Diego

 

[Guest]

Thank you so much, Diego!
I got it.

Chi,

Just include the table name at the beginning of each field in brackets,
followed by an exclamation mark.

For example... instead of having [Section 1 - Pain Intensity]
replace it for [Student]![Section 1 - Pain Intensity]

Diego

Hi,

I used the fomular below to sum the fields. I works fine. I need to add
the
table name (Student) to this fomular. Please show me how. thanks. Chi

Total Score: Nz([Section 1 - Pain Intensity],0)+Nz([Section 2 - Personal
Care],0)+Nz([Section 3 - Lifting],0)+Nz([Section 4 -
Walking],0)+Nz([Section
5 - Sitting],0)+Nz([Section 6 - Standing],0)+Nz([Section 7 -
Sleeping],0)+Nz([Section 8 - Social Life],0)+Nz([Section 9 -
Traveling],0)+Nz([Section 10 - Changing Degree of Pain],0)