Can't total a DateDiff field on form footer

[slharman1]

I am trying to use the =Sum(txtHours) on a form footer.
All I get is error, what am I doing wrong?

 

[MajP]

In expressions always use [] for controls and fields
=Sum([txtHours])
if txthours is a calculated control lets say =[Mins]/60 you have to go to the source. You cannot sum a calculated control
you have to sum the original expression
=sum([mins]/60)

 

[slharman1]

In expressions always use [] for controls and fields
=Sum([txtHours])
if txthours is a calculated control lets say =[Mins]/60 you have to go to the source. You cannot sum a calculated control
you have to sum the original expression
=sum([mins]/60)

Yes sir, Thank you!
I had the brackets (not shown in my post) but it is indeed a calculated field - went to the source and viola, it works!