what is wrong with this?

[Becky]

=((nz([Total Of Task
Number]),0)+(nz([AllTasksWhereDu eDate<EndDate_C rosstab].Report![Total
Of Task Number]),0)+(nz([subAllTasksWher eDueDate=EndDat e_Crosstab].Report![Total
Of Task Number]),0)+(nz([srpAllTasksWher eDueDate>EndDat e_Crosstab].Report![Total
Of Task Number]),0))


I have a textbox set to this in my report, which is trying to add
values from 3 different subreports. it returns #error

[Bas Cost Budde]

Re: what is wrong with this?

Becky wrote:
[color=blue]
> =((nz([Total Of Task
> Number]),0)+(nz([AllTasksWhereDu eDate<EndDate_C rosstab].Report![Total
> Of Task Number]),0)+(nz([subAllTasksWher eDueDate=EndDat e_Crosstab].Report![Total
> Of Task Number]),0)+(nz([srpAllTasksWher eDueDate>EndDat e_Crosstab].Report![Total
> Of Task Number]),0))
>
>
> I have a textbox set to this in my report, which is trying to add
> values from 3 different subreports. it returns #error[/color]

The name of the control is probably equal to some fieldname in the report.

--
Bas Cost Budde

http://www.heuveltop.org/BasCB

but the domain is nl