Are hours in units of time or text? If text your 1920's must be "1920"
--
Milton Purdy
ACCESS
State of Arkansas


"Steve Stad" wrote:

Whats wrong with this expression in text box on main form reading value of
field [SumOfEmp_Act_Prod_Hrs] in subform named 'qry_Emp_TotalHrsWorked
subform' - it is getting #name? error

=IIf([Forms]![qry_Emp_TotalHrsWorked
subform]![SumOfEmp_Act_Prod_Hrs]1920,"EMP HOURS ARE GREATER THAN 1920","Emp
Product Hours Less Than 1920")