adding fields on a report

[Stacey]

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

 

[boblarson]

You have to account for nulls:

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

 

[Stacey]

Thank You!

 

[boblarson]

 

[Stacey]

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.

 

[boblarson]

The icon looks like this:

 

[Stacey]

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?

 

[boblarson]

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