totals

[Guest]

I have a report named (individual Schedule qry) text box name (SumOfHours) the texbox name (SumOfHours
the subreport name is (attendance and Date Query) the textbox name is =Sum([Hours]
I have tried getting one total from the text boxes but it keeps coming up with #name? How would i write this? And can i put it in my header

 

[Fons Ponsioen]

I think the problem you have is that you did not rename
the textbox. If you put a formula in a textbox like "=Sum
([Hour]) the textbox name can not be the name of any data
boxes in the underlying table or query. If the textbox
name is "Hour" you could simply change the name
to "HourSum" and that should resolve the problem.
Good Luck
Hope this helps
Fons

-----Original Message-----
I have a report named (individual Schedule qry) text box

name (SumOfHours) the texbox name (SumOfHours)

the subreport name is (attendance and Date Query) the textbox name is =Sum([Hours])
I have tried getting one total from the text boxes but it

keeps coming up with #name? How would i write this? And
can i put it in my header