ErrorMsg: Can't find the field 'Forms' referred in your expression

[Rishi]

Hi.
I have:
--> A Table
[Date] [JobID] [JobStdTime] [Day0] [Day1]
--> Form
[Date]
--> SubForm (Continuous Forms)
this is (re)queried when a date is entered, and results in only the jobs of
that day
[JobID] [Day0] [Day1] [Total]=[Day0]+[Day1]
[TimeNeeded]=[Total]*[JobStdTime]

Problem:
In the Subform Footer I want to have a total of the TimeNeeded

I tried:
[TotalTimeNeeded] = SUM(TimeNeeded)

This results in #Error
And a messagebox:
...Can't find the field 'Forms' referred in your expression
You may have misspelled the fieldname, or the field may have been renamed or
deleted

There was never a field called 'Forms' on this form or in the table

PS:
Just for fun I tried:
[TotalTimeNeeded]=Sum(1)
and this returned the number of records on the subform

Can anyone explain what happens, and how I can get my TotalTimeNeeded

 

[golfinray]

use a textbox and set it to =sum([yourfield]) and then use the label to label
the sum.