奇怪的计算结果 [英] Strange Calculation Results

问题描述

我正在使用Access 2003，数据库的文件格式是2000.我有一个

计算对我来说很好但是当另一个用户登录并运行时

相同的报告她收到#Error而不是数字。她正在使用Access 2002.我查看了引用并注意到我使用的Microsoft Access对象库是11.0而另一个用户有10.0。这可能是问题所在。如果是这样，我怎么解决这个问题，因为她的名单中没有11.0。如果这不是其他可能性的原因吗？


仍然试图解决这个问题并提出其他奇怪的问题。我已经使用Access 2002打开了报告并摆弄了计算。有14个领域被加在一起。添加第14个字段时，我只收到错误。如果我在计算中只添加了13个字段，那么我不再收到#Error消息而是一个数字。我可以加在一起的数量是否有限制？


由于上述计算问题，我最终创建了两个文本框，并将每个字段中的一半字段相加。这很好，我不再有错误，但数字。但是现在当另一个用户（也使用2002）运行报告时，她什么也看不见。我不知道为什么总会有不同的结果取决于用户打开报告的内容。任何人都可以了解Access正在发生的事情。提前感谢您提供的任何帮助。

I''m using Access 2003 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. She is using Access 2002. 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?

Still trying to resolve this and coming up with other strange problems. I have opened the report with Access 2002 and fiddled with the calculations. There were 14 fields that were being added together. I only received the error when adding the 14th field. If I only added 13 fields in the calculation then I no longer received the #Error message but a number. Is there a limit to how many numbers I can add together?

Because of the above problem with the calculations I ended up creating two textboxes and summing half of the fields in each. That worked fine and I no longer had errors but numbers. But now when another user (also using 2002) runs the report she doesn''t see anything. I don''t know why there is always a different result depending on what users is opening the report. Can anyone shed any light on what is happening with Access. Thanks in advance for whatever help you can give.

推荐答案

我无法想象它可能是什么，但那时我不是不同版本的专家。


尝试思考时，可能有助于查看您正在讨论的计算结果。我无法承诺任何事情，但是用纯粹抽象的术语进行逻辑思考总是比较困难。

I can''t think of what it may be, but then I''m no expert on different versions.

It may help, when trying to think about it, to see the calculations you''re talking about. I can''t promise anything, but it''s always harder trying to think logically in purely abstract terms.

在你的用户PC上，如果看看引用，你看到了吗？缺少引用？

On your users PC, if you look at references, do you see any missing references?

我检查了引用，然后检查了不同的库（10.0和11）没有错。没有什么遗漏。

I have checked the references and other then the libraries being different (10.0 and 11) there is nothing wrong. Nothing is missing.

这篇关于奇怪的计算结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！