Calculation Error

[Ann]

I'm using Access 2002 and the file format for the DB is 2000. I have a
calculation that works fine for me but when another user logs on and runs the
same report she receives an #Error instead of the number. I looked at the
references and noticed the Microsoft Access Object Library I am using is 11.0
and the other user has 10.0. Could this be the problem. If so, how do I fix
this since she doesn't have 11.0 in her list. If it's not this what other
possibilities could there be?

 

[Ann]

Sorry, I made a typo. It's 2003, not 2002. I also fiddled with the
calculation. There were 14 numbers that were being added together. I only
received the error when adding the 14th number. If I only added 13 of them I
no longer received the #Error message. Is there a limit to how many numbers
I can add together?

 

[fredg]

Sorry, I made a typo. It's 2003, not 2002. I also fiddled with the
calculation. There were 14 numbers that were being added together. I only
received the error when adding the 14th number. If I only added 13 of them I
no longer received the #Error message. Is there a limit to how many numbers
I can add together?

It would have been helpful had you posted the exact expression you are
using.
Does your expression take into account a Null value being added?