报告：文本框按报告的上次日期对设施的#inches求和 [英] Reports: textbox to sum a facility's #inches by last date reported
问题描述
您好，
我尝试了各种各样的方式，无法通过这个方式。
[设施]将[每周]报告[#inches ]。这仅用于跟踪测量。我希望仅根据报告月份的[上次报告日期]获得所有设施的#inches总和。
基于每个[设施的[上次报告日期] ]，总和[#inches]
因此，设施A报告为1-3-14（5英寸），1-9-14（10英寸），1-15-14 （40英寸），1-21-14（2英寸）
1-21-14 = 2英寸设施A
1-15- 14 = 17英寸的设施B（以上为例）
...仅使用2作为示例
总和= 1英寸19英寸/>
我尝试将Max与没有赢家合并。
谢谢
Hello,
I have tried various ways and cannot get through this one.
A [facility] will report [weekly] their [#inches]; this is for tracking measurements only. I am looking to get the sum of #inches for all facilities based only on the [last reported date] of the reported month.
Based on [last reported date] of each [facility] , sum [#inches]
So, facility A reported on 1-3-14 (5 inches), 1-9-14 (10 inches), 1-15-14 (40 inches), and 1-21-14 (2 inches)
1-21-14 = 2 inches for Facility A
1-15-14 = 17 inches for Facility B (following ex above)
...just using 2 for the example
Total Sum = 19 inches for January
I tried incorporating Max with no winners.
Thank you
推荐答案
显示我们尝试合并最多的代码
Show us the code where you tried to incorporate max.
在报告的未绑定文本框中：
In an unbound textbox on the report:
您是否尝试使用将Running Sum属性设置为Over Group的文本框？然后，您可以按设施或日期对数据进行分组，以最适合您的方式为准。如果按日期对记录进行分组，则可以按月或按周将其分解。
Have you tried using a text box with the Running Sum property set to Over Group? You could then group your data by either Facility or Date, whichever works best for you. If you grouped your records by date, you can then break them down by either month or week.
这篇关于报告：文本框按报告的上次日期对设施的#inches求和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
