Getting the SUM

[jgrau via AccessMonster.com]

I am having extream trouble totaling fields in a query. I am trying to total
numbers in several different fields in a query to populate a field in my form
Example:

WorkMonthsUsed: [Test1].[WMU]+[Test2].[WMU]+[Test3].[WMU]+[Test4].[WMU]

It will let me total two fields but when I enter another It fails.

Any Ideas?

"Thanks for your Support"

 

[KARL DEWEY]

Probably some nulls. Try this --
WorkMonthsUsed:
Nz([Test1].[WMU],0)+Nz([Test2].[WMU],0)+Nz([Test3].[WMU],0)+Nz([Test4].[WMU],0)

 

[John W. Vinson]

I am having extream trouble totaling fields in a query. I am trying to total
numbers in several different fields in a query to populate a field in my form
Example:

WorkMonthsUsed: [Test1].[WMU]+[Test2].[WMU]+[Test3].[WMU]+[Test4].[WMU]

It will let me total two fields but when I enter another It fails.

Fails... in what way? Error message? Null result? Computer catches fire?

How are your four tables related? Could you post the SQL view of the entire
query? Are you <shudder> using four identical tables for four different tests?