更新时间: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
感谢您抽出宝贵时间发表回复,非常感谢您的帮助。
Thank you for taking the time to post a response, your assistance is very much appreciated.
给这个测试人员
>