且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

根据日期范围运行总计

更新时间:2023-01-30 08:40:09

我在试图找出如何使这项工作时注意到的事情是,我正在使用的功能是通过我表中的每个记录来计算运行金额/总额。


也许我需要使用Between日期范围标准 -

[FORMS]之间![frmBCPIC]![date1]和[FORMS]![frmBCPIC]![date2]在运行的总函数中而不是在标准中。


我将尝试看看会发生什么。
Something I have noticed in trying to figure out how to make this work is, that the function I am using is going through every record in my table to make the running sum/total.

Perhaps I need to use the Between date range criteria -
Between [FORMS]![frmBCPIC]![date1] And [FORMS]![frmBCPIC]![date2] in the running total function instead of in the criteria.

I will give that a try and see what happens.



我在试图找出如何使这项工作时注意到的一点是,我正在使用的功能是通过我表中的每个记录来计算运行金额/总额。


也许我需要使用Between日期范围标准 -

。运行总函数中的[FORMS]![frmBCPIC]![date1]和[FORMS]![frmBCPIC]![date2]之间而不是标准。


我会尝试一下,看看会发生什么。
Something I have noticed in trying to figure out how to make this work is, that the function I am using is going through every record in my table to make the running sum/total.

Perhaps I need to use the Between date range criteria -
Between [FORMS]![frmBCPIC]![date1] And [FORMS]![frmBCPIC]![date2] in the running total function instead of in the criteria.

I will give that a try and see what happens.



给这个testrun

give this a testrun

展开 | 选择 | Wrap | 行号


感谢您抽出宝贵时间发表回复,非常感谢您的帮助。

Thank you for taking the time to post a response, your assistance is very much appreciated.


给这个测试人员
>
展开 | 选择 | Wrap | 行号