Hi
i want to add 2 columns, however one of the columns may have no value in.
For example
<tbody>
</tbody>
i've created the expression [tblAL]![Hours]+[tblCC]![Hours]
however the results i get are
<tbody>
</tbody>
What is the expression i should be using?
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?