Hi have a simple =Sum([Hours]) text box in the footer of the subform and on the main page =[Billing Hours subform]![Text16] in another text box, this add all the hours completed by each employee
Works fine
But when I add another =sum([Total]) text box and =[Billing Hours subform]![Text20] the Total being the result of Hour*Rate (works fine in subform)
but I get an error message in both text boxes on the main page, I am unsure why this is happening
Many Thanks