Adding in Subform causing an error message

[keiath]

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

[June7]

Aggregate functions can only reference fields, not calculated textboxes.

Do the Hour*Rate calculation in RecordSource then reference that constructed field.

Or in textbox:

=Sum([Hour] * [Rate])

[keiath]

Thanks yeah rates of each emp is different so its not a simple hour*rate so will need to query

Thanks again