CODEWITHSUNDEEP
ms-access
Matt H
Matt H

Reputation: 147

MS ACCESS EXPRESSIONS

Just a quick question regarding conditional formatting/Expressions. I have a form which holds information (Invoice Date, Payment terms, Payment Due, Days Left, and Paid).

Payment due adds 30 days on to the Invoice date and Days left shows us how many days left that it has.

My question is how can I make it so that when the tick box "Paid" is ticked then it sets the Days Left to 0 or Blank. rather than continuously counting down.

enter image description here

Upvotes: 0

Views: 42

Answers (1)

June7
June7

Reputation: 21370

Could use an IIf() to conditionally adjust DaysLeft based on value of checkbox.

=IIf([Paid], 0, days left calc here)

Upvotes: 1

Related Questions