在子表单中减去日期 [英] Subtract dates in subform

问题描述

我有一张带有字段的表格 -

Income_Date Income。

19/3/07 $ 320

21/2/07 $ 200

27/1/07 $ 300


在连续子表格中，我需要为每个收入期显示每行的平均每周收入。据我所知，到目前为止，我需要使用datediff函数来计算两个日期之间的差异，然后循环到下一个记录并重复。我只是不知道如何实现这一目标。


请有人帮我提供我需要使用的代码，以及如何使用它？如果它还没有明显的痛苦，我是新来的 - 在我发疯之前，我会非常感激任何建议。

I have a table with the fields -
Income_Date Income.
19/3/07 $320
21/2/07 $200
27/1/07 $300

In a continuous subform, I need to show for each income period the average weekly income on each line. As far as I can figure so far, I need to use the datediff function to calculate the difference between the two dates, and then loop to the next record and repeat. I just have no idea how to achieve this.

Please can somebody help me with the code I need to use, and how to use it? In case it''s not already obvious painfully, I''m new to this - any suggestions would be much appreciated before I go nuts.

推荐答案

320

21/2/07

320
21/2/07

200

27/1/07

200
27/1/07

300


在连续子表格中，我需要为每个收入期显示每行的平均每周收入。据我所知，到目前为止，我需要使用datediff函数来计算两个日期之间的差异，然后循环到下一个记录并重复。我只是不知道如何实现这一目标。


请有人帮我提供我需要使用的代码，以及如何使用它？如果它还没有明显的痛苦，我是新手 - 在我发疯之前，我会非常感激任何建议。

300

In a continuous subform, I need to show for each income period the average weekly income on each line. As far as I can figure so far, I need to use the datediff function to calculate the difference between the two dates, and then loop to the next record and repeat. I just have no idea how to achieve this.

Please can somebody help me with the code I need to use, and how to use it? In case it''s not already obvious painfully, I''m new to this - any suggestions would be much appreciated before I go nuts.

这篇关于在子表单中减去日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！