#Size error in Report

[Leopard011]

Hello!

I have a textbox in report which should sum 3 fields, The first error occurred because sometimes one of the fields returns NULL, so I've used Nz function, the problem is it's now returning #size error :banghead:

The expression is as follows:

=Nz([Query_1].[Report]![invoice],0)+Nz([Query_1].[Report]![cash],0)+Nz([Query_1].[Report]![cheque],0)

After googling it for a while, I suppose this error occurred if there was no record resulted in the query, therefore I should use a Iferror function, and I don't know how!

 

[pbaldy]

Those references look off. Try simply:

=Nz([invoice],0)+Nz([cash],0)+Nz([cheque],0)

 

[Leopard011]

They are referring to fields in subreport.

 

[pbaldy]

Oh, I misunderstood. How about:

http://access.mvps.org/access/forms/frm0022.htm

 

[Leopard011]

Dear Paul,

Thanks for your help, really appreciated.

As for the link, I'm a little bit confused, how could I use it as an expression not using VBA?

 

[arnelgp]

=IIF([Query_1].[Report].HasData, Nz([Query_1].[Report]![invoice],0)+Nz([Query_1].[Report]![cash],0)+Nz([Query_1].[Report]![cheque],0), 0)

 

[Leopard011]

Dear Arnelgp,

Thank you so much, worked fine