Calculating totals on forms

[chainbr8kr]

I have a form that shows data totals from one query and within the form I have a subform displaying totals from a different query. Can I calculate these totals together to display one average on the form? I tried a couple of formulas but it's not working. Can this be done? Thanks!

=Avg([Forms]![frmSup_QA_Results]![Sup_Avg]+[Forms]![frmQA_Results]![QA_Avg])

 

[Mike Gagnon]

Is your question related to FoxPro? Your formula does look like VFP code.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[rgbean]

Mike,
I believe the "subform" comment tends to indicate it's most likely Access VBA code.

Rick