Hi,
PROBLEM:-
I have been given the task of setting up a new database for work. One of the pages within the form contains a set of 6 drop downs each containing numbers 1-6. What I need is another box that automatically works out the average of the 6 selected numbers. I have tried entering different formulae within an unbound text box but cannot seem to get any result other than either a totally random figure or an "#ERROR" message. Can anyone give me an idea of how to get this working please? Any help greatly appreciated. This is my first thread although some of the other comments have really helped my design so far.