Leopard011
New member
- Local time
- Today, 03:39
- Joined
- Jan 14, 2012
- Messages
- 9
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!
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!