I keep a fairly simple report going to monitor staff for a voluntary organisation. We have three categories of staff and simple text boxes calculate the nummbers in each category from a Query. The categories are:
Long Term [text box 29]
Short Term [text box 31]
Day Worker [text box 76]
The calculation used to total these categories is:
=[text29]+[text31]+[text76]
I've recently added a new catogory:
Student [text box 420]
I've amended the text box that calculates the totals to now read:
=[text29]+[text31]+[text76]+[text420]
However, instead of a total appearing I get "1E" appear instead of the actual total of all 4 text boxes.
I'm baffled. The text box that counts the students seems to work and gives the correct result. But when I add <+text420> to the results text box I get the 1E printed instead of the combined total of all text boxes. I delete text box 420 and all is well again.
Please help and many thanks
Nik
Long Term [text box 29]
Short Term [text box 31]
Day Worker [text box 76]
The calculation used to total these categories is:
=[text29]+[text31]+[text76]
I've recently added a new catogory:
Student [text box 420]
I've amended the text box that calculates the totals to now read:
=[text29]+[text31]+[text76]+[text420]
However, instead of a total appearing I get "1E" appear instead of the actual total of all 4 text boxes.
I'm baffled. The text box that counts the students seems to work and gives the correct result. But when I add <+text420> to the results text box I get the 1E printed instead of the combined total of all text boxes. I delete text box 420 and all is well again.
Please help and many thanks
Nik
