Calculating Averages

[chr1stoper1]

Hi Guys



I am making a new database to store data on moisture levels in different materials.
I am using a form to populate a table of material moisture samples . Each Material has three samples taken . I am trying to either get the form to average the three samples or use a calculated field in the table but I am not having any luck at all. It will probably be pretty straight forward but I don't seem to be able to do it .Any help is appreciated

[chr1stoper1]

Just checked again and the field in the table was set to short text instead of number . dohh