Thread: Converting Null Values to Zero

Trying to change null data to zero using an iif statement.

ultimately what I am trying to do is have a current readout of the amount that is in a checking account.

I am trying to do this using select queries. There are 4 catagories. Expenses, Income, Transfer In, Transfer Out

I made 4 queries to find those catagories totals and they are:

QryPriChkgExpTot
QryPriChkgIncTot
QryPriChkgTranInTot
QryPriChkgTranOutTot

I found that in my dummy data that I neglected to put a transfer in and so when I ran that query it continues to come empty. Consequently anything i run using that data doesnt treat it as 0 so further down the line I get an empty as well. I tried to handle this with an iif statement and it doesnt work. Any suggestions

particularlly pay attention to QryPriChkgTranInTot and see how it doesnt have a value when run. I considered this to be a null. Am I mistaken?

Just use the Nz() function.

with such a strong approval of the Nz funct ill have to most certainly do that. I hope the help on it is somewhat complete. Thanks guys

Just post back here if you need more assistance. Pleanty of people willing to help.