need some help totaling a column on a report

[Jon123]

I have a field called [Number of Children] on the footer of the report I have a undound box with this in the control source

=Sum(Nz([Number of Adults],0))

but I always get an error when the report opens.

why? please advise

jon

 

[MarkK]

You need to provide more details about the error. That it happens when you open the report is a good start.

 

[Jon123]

Re: need some help totaling a colum on a report

Sorry, yes the report opens but the data in the textbox reads #ERROR and that is it

 

[Jon123]

Re: need some help totaling a colum on a report

figured it out

thanks

 

[boblarson]

figured it out

thanks

Can you post the answer - it might help someone else in the future.