add two coloumns in a query

[kisnay82]

Hi
i want to add 2 columns, however one of the columns may have no value in.
For example

[TABLE="width: 500"]
<tbody>[TR]
[TD]AL[/TD]
[TD]CC[/TD]
[TD]AL+CC[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]7[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]7[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

i've created the expression [tblAL]![Hours]+[tblCC]![Hours]

however the results i get are

[TABLE="width: 500"]
<tbody>[TR]
[TD]AL[/TD]
[TD]CC[/TD]
[TD]AL+CC[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]7[/TD]
[TD]14[/TD]
[/TR]
</tbody>[/TABLE]

What is the expression i should be using?

 

[Joe4]

Mathematical computations do not like Null values. Convert the nulls to zeroes with the NZ function, i.e.

[COLOR=#333333]Nz([tblAL]![Hours],0)+Nz([tblCC]![Hours],0)[/COLOR]