子表单总和错误 [英] Subform Sum error

问题描述

你好，


我在frmAggrSub中的Sum'有错误。我在页脚中有4个未绑定的文本框，1是qryProduction的百分比，所以我可以理解它的0是否错误。但是，另外3个Sum在子表单中输入了数字。感谢任何帮助


编辑：上传的文件在frmAggrSub中的AggrPerc文本框中的默认值为0。我刚刚纠正了这一点，它导致数据输入问题。但我说的其余部分仍在发生

Hello,

I have a error for Sum''s in frmAggrSub. I have 4 unbound text boxes in the footer, 1 is a percent of qryProduction so I can understand if its 0 than a error. However the other 3 only Sum entered numbers in the subform. Any help is appreciated

The uploaded file has a default value of 0 in AggrPerc textbox in frmAggrSub. I just corrected that, it was causing data entry issues. But the rest I stated is still happening

推荐答案

你需要在线程中提出完整的问题。期待人们上传你的数据库以确定问题应该是不可接受的。


我在其他地方解释，但它有助于所有实例都以这种方式标记，所以任何人都在寻找和看看这里发生的事情并不是一件错事。应该做些什么。


我之前解释过技术问题，但我会再说一遍，他们需要充分，谨慎地表达出来。使用您可以管理的最佳术语。如果你谈论控制但不解释他们在表格，甚至是子表格，那么我们的帮助能力就会受到严重限制。在所有情况下都要仔细阅读你的问题并解决任何问题，特别是OP（OP = Opening Post以及Opening Poster。这里用作前者）。


理想情况下，很少有人能够管理这种能力水平，但理想情况下，应该发布问题并给出答案，这就是结束。想象一下谷歌搜索他们的问题找到这样的线程的价值。 Simples。问题问及回答。完善。在现实生活中，我们只是为了达到目标。它确实需要一点点努力，但不仅在寻求帮助时这是合理的，它还有一种方式也可以用不太明显的方式使你受益。

You need to put the full question in the thread. Expecting people to upload your database in order to determine what the question should be is not acceptable.

I do explain that elsewhere but it helps that all instances are flagged this way so anyone looking and seeing what goes on here is under no illusion how things are supposed to be done.

I explained before about technical questions but I''ll repeat they need to be expressed fully, carefully and using the best terminology you can manage. If you talk about controls but don''t explain they''re on a Form, or even a SubForm, then our ability to help is severely curtailed. Reading through your question and fixing any problems is expected in all cases but particularly for OPs (OP = Opening Post as well as Opening Poster. It''s used here as the former).

Ideally, and very few manage this level of competence, but ideally, questions should be posted and an answer given and that''s the end of it. Imagine the value to someone Googling for their problem to find such threads. Simples. Question asked and answered. Perfect. In real life we just aim for that target. It does require a little effort, but not only is that reasonable when asking for assistance, it also has a way of benefitting you too in less obvious ways.

我不知道如何解释除了我有一个未绑定的文本框使用sum函数返回错误，除非在另一个中看起来完全不相关的字段的值大于0？

I don''t know how to explain other than I have a unbound textbox using the sum feature that returns a error unless what seems to be a totally unrelated field in another has a value greater than 0?

我很抱歉我加重了你，但我做了其他建议的改变，所以现在我遇到的问题已经从我最近的2篇帖子中提出。生病的想法谢谢


如果可能，请删除我的帐户。谢谢Twinny我非常感谢你的帮助。

Im sorry Im aggravating you but I made the changes off other advice offered so now Ive encountered issues that has risen from that which are in my last 2 post. Ill figure out thanks

Mod if possible please delete my account. Thanks Twinny I eally appreciated your help.

这篇关于子表单总和错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！