Probably a simple error.

[D.Mair]

I have a Report takes invoice 3 totals from a query then adds the total of all invoice 3's. The problem is that if there have been no invoice 3 the total comes up as an error how do I stop this. I want it to say £0

My Control Source is

=Sum([Invoice Amount 3])

 

[amayer]

You need the null value function which is Nz. I believe that your function would be
=Sum(Nz[Invoice Amount 3]). You can look up the Nz function in the help too.

Tony

 

[D.Mair]

I had tried this but it didn't work.
=Sum(Nz[Invoice Amount 3])
I got an error saying the expression you entered contains invalid syntax. You may have entered an operand without an operator.
I am stuck on this one.
Thanks for your help