Help: Can't add two fields in a query unless data in both

[clevelander]

Hi,

I am hoping you can help me with an Access problem I am having. I have a query where I am trying to add two fields from a table. For some reason, I only get a result when there is data in both fields. Example:

Field_A      Field_B      Query_addition_result:
2               4                6
5                                 
                7                
8               1                9

Any ideas? Thank you so much in advance for your help!!

[nico5038]

Try:

select Field_A, Field_B, 
       NZ(Field_A)+NZ(Field_B) as Query_addition_result from tblX;

This will neutralize the effect of Nulls.

Nic;o)