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

AL	CC	AL+CC
	7	7
7	7	14

<tbody>
</tbody>

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

however the results i get are

AL	CC	AL+CC
	7
7	7	14

<tbody>
</tbody>

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]