我需要缩小访问报告中哪些数据的范围？

Question

我想要显示OFFICE下的水成本，如果在RR后5-7天。如果在7天后，显示在RECEIVED AFTER WELL CLOSED下，则5天以下的所有内容都显示在FIELD下。

这是当前使用的代码，尚未更新以反映上述条件：

Entry: IIf(Date()>=[RR]+5,"OFFICE","FIELD")

Answer 1

在公式中嵌入另一个if条件：

IIf(Date()>=[RR]+7,"RECEIVED AFTER WELL CLOSED",IIf(Data()>=[RR]+5,"OFFICE","FIELD"))

Answer 2

您可以使用switch函数执行此任务：

switch
(
    Date()-RR >  7, "RECEIVED AFTER WELL CLOSED",
    Date()-RR >= 5, "OFFICE",
    True, "FIELD"
)