ms-accessms-access-reports

I need to narrow down what data pulls through on the Access Report?


I want to show water cost under OFFICE if between 5-7 days after RR. If after 7 days, show under RECEIVED AFTER WELL CLOSED, everything under 5 days shows up under FIELD.

This is the current code being used that has not been updated to reflect the above criteria:

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

Solution

  • Embed another if condition into the formula:

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