Access query that adds two columns where one is sometimes a null

I have this query:

Expr1: [TABLE]![COL1]+[TABLE]![COL2]

it's not working because sometimes either column can be a null, in that case I want it to treat the null like a 0 and add them anyways. Can I modify the query to do this?

Thanks!
Coaster_brook_troutAsked:
Who is Participating?
 
luconstaCommented:
Use the NZ function:

Expr1: NZ([TABLE]![COL1],0)+NZ([TABLE]![COL2] ,0)
0
 
Coaster_brook_troutAuthor Commented:
PERFECT, EXACTLY WHAT I WAS LOOKING FOR!!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.