Need help with totalling a field in Subform

[Astron2012]

Hi,

This should be really straightforward but for some reason I am experiencing a total nightmare with this!

I have a form containing a subform (JobDetailsSub) set to Continuous forms. The subform is controlled by a query. The query contains some calculated fields. One field is HoursToday (a sum of 4 other fields). I want to total the HoursToday field in the footer of the main form. I have tried all options I can think of but still getting #error. I thought it should be as simple as =Sum( [JobDetailsSub].Form![HoursToday] ) but this is not working.

I know you cannot sum a calculated field in a form but I thought as it was calculated in the query it would still work. Is this not the case?

Please help!



Many Thanks

[Astron2012]

Its OK, just been informed I should put the textbox in the subform footer not the mainform footer,

Now works!