Hi,
I have a simple DB, and a table contains three numeric fields which are measurements taken on the same item to assess consistency. Obviously I can show these values on the form and report, I now need to calculate an average of these three fields and show this value on the form and report.
Sounds simple but its driving me up the wall!!
Can anybody help me with this please? I thought it could be done in a similar way to calculating averages in Excel (functions etc.. in a text box) but I cannot seem to get it right!!
Apologies if this should be in Tables/Reports etc - I couldn't decide where it should go!!
Thanks in advance,
Swifty
I have a simple DB, and a table contains three numeric fields which are measurements taken on the same item to assess consistency. Obviously I can show these values on the form and report, I now need to calculate an average of these three fields and show this value on the form and report.
Sounds simple but its driving me up the wall!!

Can anybody help me with this please? I thought it could be done in a similar way to calculating averages in Excel (functions etc.. in a text box) but I cannot seem to get it right!!
Apologies if this should be in Tables/Reports etc - I couldn't decide where it should go!!
Thanks in advance,
Swifty
