G
Gerard Walsh
I have a form which has 7 combo box fields named 'MonHrs'
through to 'SunHrs' and I pick from a list box containg
numbers from 1 to 12 in each field (representing hours
worked by Tutors).
After I have entered the numbers, I want the total of all
7 fields to be totalled up in a text box field
named 'WkTotalHrs'. I have set the properties data
control source to; =[MonHrs]+[TueHrs]+[WedHrs] and so on
to '+[SunHrs] but when I run the form and enter the
numbers into the 7 fields the WkTotalHrs field
has '#NAME?' in it and I just cannot find a way to make
it work. It did not work using a combo box either.
Can somebody help me?
Gerry
through to 'SunHrs' and I pick from a list box containg
numbers from 1 to 12 in each field (representing hours
worked by Tutors).
After I have entered the numbers, I want the total of all
7 fields to be totalled up in a text box field
named 'WkTotalHrs'. I have set the properties data
control source to; =[MonHrs]+[TueHrs]+[WedHrs] and so on
to '+[SunHrs] but when I run the form and enter the
numbers into the 7 fields the WkTotalHrs field
has '#NAME?' in it and I just cannot find a way to make
it work. It did not work using a combo box either.
Can somebody help me?
Gerry