I have a form that contains 2 other subforms. The main form's fields list doesn't contain the field that i need to do the calculation. The field i need is in a query..so when i try to put this on the main form, inside a txtbox's control source =avg([QueryTable]![QueryField]), it just gives me #name. <br>Anyway around this?<br>thanks,