Using Calculated fields in other controls - help please!!

[commandolomo]

Hello all

Quick question - is it possible to use a calculated field as a condition in another control?

For example, I have a field (text box), called "CurrentHours," that it's control source is an IIf calculation. I want to use the value in this field as part of another calculation - for example sum([CurrentHours] / 37). Yet when I do this I am getting an "Enter Parameter Value" input box.

Is it possible to reference a value within a text box within another calculation?

Cheers for any help

 

[Rich]

Repeat the calculation Sum(Iif( whatever etc,, ))/37

 

[commandolomo]

Cheers Rich, sorted