NULL in an expression = NULL???

[kaluapig]

Hello all!

Can someone provide advise?

I am running a query against one table. There are a total of 5 fields in this query, four of which are from the queried table and the other field is an expresssion that adds the four other fields.

For example:

FIELD5: [FIELD1] + [FIELD1] + [FIELD2] + [FIELD3] + [FIELD4]

There are instances where all four fields can have a NULL value. When this happens, FIELD5 = NULL.

The challenge I am encountering now is that if I use FIELD5 in an expression, and lets say add a number to it, the result of that new expression will equal NULL. So what this is telling me is that if one has a NULL in any expression, the answer will = NULL.

If this is true, what can I do to get around it?

Thanks for your input!

Nick

 

[pbaldy]

You can use the Nz() function to replace Null with zero.

 

[kaluapig]

Thanks A Bunch!

The Nz() Function Worked Like A Charm!

Aloha!

Nick