问题描述
我正在尝试生成一份报告，以显示赠款的余额。当授权中有多个项目时，它不起作用。 rptGrantBalance基于qryExpDetail。字段包括ProjectNo / Budget / Expense / Balance
如果只有一个授权我得到了正确的结果但是如果有多个项目，预算只会为第一个项目提取预算费用增加了所有项目的费用。 GroupHeader包括GrantNo和ProjectNo。
如何解决这个问题？
如果需要进一步的信息，请告诉我。谢谢。
I am trying to generate a report to show remaining balance on a grant. It does not work when there are more than one project in a grant. rptGrantBalance is based on qryExpDetail. Fields include ProjectNo / Budget / Expense / Balance
If there is only one grant I get correct result but if there is more than one project, the budget only pulls budget for the first project although the Expense adds expenes for all projects. GroupHeader includes, GrantNo and ProjectNo.
How can I fix this problem?
Let me know if further information is needed. Thanks.
推荐答案
这篇关于报告页脚会跳过记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！