Access 2010. Is there a way to SUM an AVERAGE calculated value with another field. They will sum individually but not together. In my report, Im using: =Avg([NetWtAVG]) to get the correct average for this field named "AvgWT". I have another field of =SUM([NetWt]) named "NtWt". I have spent days trying to add these two controls together without any luck.
I keep getting erronious results. I've tried,among others:
=[AvgWt]+[NtWt]
=Avg([NetWtAVG]+SUM([NetWt])
=SUM([AvgWt]+[NtWt])
I've also placed the control in various group headers and group footers.
Help please.