在日期之间搜索 [英] Searching between dates

问题描述

我有一个命令按钮，它运行宏来打开报告。在宏的Where Condition中，我有以下Year（[Next Review Date]）= Year（Date（））" +。


这是好的，如果我只想要第二年，但是我希望它也返回租金评论仍然有效，并且还没有提前一年解决。任何帮助将不胜感激。

I have a command button which runs a macro to open a report. In the Where Condition of the macro I have the following "Year([Next Review Date])=Year(Date())"+1.

This is good if I want the following year only, however I would like it to also return Rent Reviews which are still active and have not been settled as well as ones one year in advance. Any help would be greatly appreciated.

推荐答案

租金尚未结算的条件是什么？我期待像RentPaid这样的东西。 RentOwed


什么是仍然有效条件，或者它们是同一个吗？


Phil

What is the condition where the rent has not been settled? I am expecting something like RentPaid < RentOwed

What is the "Still Active" condition, or are they one and the same?

Phil

Phil，如果租金审查尚未结算，那么审查日期保持不变（有些还没有结算两年，并保持日期为2014年）。一旦结算，就会在其中放置新的租金审核日期。对不起，我不明白仍然有效的问题。条件。

Phil, if the rent review has not been settled then the date of the review stays the same (some have not been settled for two years and remain dated as 2014). Once it is settled a new rent review date is placed in it. Sorry, I don''t understand the question re "Still Active" condition.

我想你错过了我的观点。您如何表明租金已经结算。必须改变以表明从未结算到已结算的变化。如果我能找到这是什么，那么你原来的Where Condition和会有一个额外的或东西......


Phil

I think you missed my point. What do you do to indicate the rent has been settled. Something must change to indicate the change from unsettled to settled. If I can find out what this is then your original "Where Condition" will have an additional "Or" something ......

Phil

这篇关于在日期之间搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！