Hi All. I am having a huge issue with a Subreport total, trying to transfer it to the main report. The thing is that the result is completely inconsistent. Sometimes it prints out 0, sometimes #error.

For testing sake, I put the total as visible and even when there is a total value, I am still getting an #Error. What I am doing wrong?

=iif([Weekly_Report_Tasks_subreport].[Report].[HasData];NZ([Weekly_Report_Tasks_subreport].[Report]![TotalWT];0);0)

Using Access 2007.... and the TotalWT value is in the subreport Report Footer section...


Thanks