error #error in MS Access???

[leetie]

I'm from Vietnam and my English is bad. In my database, I have only a table named tblEmployees, which contains these following fields: Employee_ID (data type: text), Name (text), Salary (number) and Allowance (number). I build a form bound to this table. In the footer of this form, I have a textbox control named txtSumSalary that contains the expression: =Sum([Salary]). Everythings is OK. But when I build an another textbox named txtSumAllowance that contains the expression: =Sum([Allowancess]) (I misspelled this field intentionally), the result are error #error in both textbox controls. I don't understand why the textbox txtSumAllowance wrong, the textbox txtSumSalary is wrong too. Help me!!! Thanks a lot!

 

[Rich]

=Sum([Allowancess]) (I misspelled this field intentionally)

Why did you misspell Allowances ?

 

[leetie]

That is only an example. I only want to know the reason why a control wrong, another controls are wrong too? Please explain me! Thanks!

 

[Gibbo]

I don't know why, but it is true. In a footer, if you use sum, count ave etc functions and you have a mistake in one, all the controls will display wth error messages. I would guess, but may be totally wrong, that Access is creating a summation query, in the background, to fill in the footer which fails if any part of it is wrong.

 

[leetie]

Thank you very much!