你如何在表单页脚中获得一个dlookup控件的总和？ [英] how do you get a sum of a dlookup control in the form footer?

问题描述

=总和（Dlookup（....


对我来说不起作用，因为dlookup有4个标准，表有大约15000行，总和（dlookup ...）导致访问关闭，但是dlookup工作得很好。


另一方面，Dsum不起作用，因为它占用了当前记录并且只给出了那一条记录的总数。

=Sum(Dlookup(....

does not work for me as the dlookup has 4 criteria and table has some 15000 lines, the sum(dlookup...) causes access to shut down, the dlookup however is working just fine.

Dsum on the other hand does not work as it takes the current record and gives me the total only of that one record.

推荐答案

你应该能够在DSUM中写下标准了。也许你的做法不对:)


什么你有没有试过投入DSUM，你想要它的总和是什么？

You should be able to write the criteria in DSUM. Maybe your not doing it right :)

What have you tried to put in DSUM, and what is it your want it to sum?

忘记表格形式的不良命名......


dsum可以工作，但它只给我当前记录的总计溢价字段


DSum（[PREMIUM]，[10A tblTabularPremium-]个人]，[10A tblTabularPremium-Individual]！[计划类型] =表格！[05 frmqryMainQuote - INDIVIDUAL]！[06A tblSubQuotePlan-Individual] .Form！[建议计划TY] PE - IND]和[10A tblTabularPremium-Individual]！[保险CO] =表格！[05 frmqryMainQuote - INDIVIDUAL]！[06A tblSubQuotePlan-Individual] .Form！[建议保险CO - IND]和[10A tblTabularPremium-Individual]！ [计划名称] =表格！[05 frmqryMainQuote - INDIVIDUAL]！[06A tblSubQuotePlan-Individual] .Form！[建议的计划名称 - IND]和[10A tblTabularPremium-Individual]！[年龄] =表格！[05 frmqryMainQuote - INDIVIDUAL] ！[06A tblSubQuotePlan-Individual] .Form！[06B tblSubQuoteMember-Individual] .Form！[FINAL AGE]和[10A tblTabularPremium-Individual]！[SUM INSURED] = Forms！[05 frmqryMainQuote - INDIVIDUAL]！[06A tblSubQuotePlan-Individual ] .Form！[06B tblSubQuoteMember-Individual] .Form！[PROPOSED SUM INSURED - IND MEM]"）

FORGIVE THE POOR NAMING OF THE TABLES FORMS ETC....

the dsum works but it gives me the total of the premium field only for the current record

DSum("[PREMIUM]","[10A tblTabularPremium-Individual]","[10A tblTabularPremium-Individual]![PLAN TYPE]=Forms![05 frmqryMainQuote - INDIVIDUAL]![06A tblSubQuotePlan-Individual].Form![PROPOSED PLAN TYPE - IND] AND [10A tblTabularPremium-Individual]![INSURANCE CO]=Forms![05 frmqryMainQuote - INDIVIDUAL]![06A tblSubQuotePlan-Individual].Form![PROPOSED INSURANCE CO - IND] AND [10A tblTabularPremium-Individual]![PLAN NAME]=Forms![05 frmqryMainQuote - INDIVIDUAL]![06A tblSubQuotePlan-Individual].Form![PROPOSED PLAN NAME - IND] AND [10A tblTabularPremium-Individual]![AGE]=Forms![05 frmqryMainQuote - INDIVIDUAL]![06A tblSubQuotePlan-Individual].Form![06B tblSubQuoteMember-Individual].Form![FINAL AGE] AND [10A tblTabularPremium-Individual]![SUM INSURED]=Forms![05 frmqryMainQuote - INDIVIDUAL]![06A tblSubQuotePlan-Individual].Form![06B tblSubQuoteMember-Individual].Form![PROPOSED SUM INSURED - IND MEM]")

如果您只获得当前记录，那是因为你有一个错误的标准。你真的需要所有这些吗？


我猜测只有1条记录符合你的标准，这就是为什么你只得到该记录的总和。

If your only getting it for the current record, its because you have a wrong criteria somewhere. Do you really need all those AND?

Im guessing that only 1 record meets your criteria, thats why you only get the sum on that record.

这篇关于你如何在表单页脚中获得一个dlookup控件的总和？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！