Hi.

I searched the forum and found a couple of posts regarding this, however, the situation wasn't quite the same.

I have a query that pulls back 2 separate totals , InternalRemits and ExternalRemits. On the report, I want a TotalRemits column. This is what I have : =([InternalRemits]+[ExternalRemits])

This is working if there is data in both fields. However, if there is a null value in one of the fields, it brings back a null value.

What am I doing wrong?

Thanks
Stacey

You have to account for nulls:

Nz([InternalRemits],0) + Nz([ExternalRemits],0)

Thank You!

http://downloads.btabdevelopment.com/AWF/GladWeCouldHelp.png

I don't see an icon that looks like scales on your post. I have wanted to "add to someone's reputation" a few times, but can never see the icon to do so. This is the first time I have asked about it though, so I will have to go back and make amends to others that have helped me.

The icon looks like this:

http://downloads.btlarson.com/AWF/screenshots/Rep.png

All I see is #6 on the post you just made. Do I have to change a setting somewhere or go to directly to your profile?

can you post a screen shot of what you're seeing?