If Statements on the basis of 'Yes/No' being ticked or not - please see detail below

[Chaz]

Difficult to know how to title this request for help ...

I have a textbox with "=DateDiff("d",Now(),[ACR_Submit_Date_Time])" which works well and I can then colour this using the conditional formatting.

How / Where do I look at excluding this count if say a yes/no box has been triggered. Should I go back to the source of the form and do a query that may exclude certain items if they are not ticketed?

Just not sure where to go to do the logic and am not keen on VBA (even though I should probably learn at a stage).

So, to recap. I have a simple form - if a certain box is ticked, then this day count is valid and needs to be coloured. If the certain box is not ticked, the DateDiff calculation should be ignored completely and perhaps even say 'Not Applicable' or something similar.

Thanks in advance ...

 

[namliam]

Check out the IIF function...

 

[Chaz]

Check out the IIF function...

Will do, but where do I use it?

 

[Chaz]

Ive managed to get a new text box highlight whether or not something is valid based on the yes/no of another box. How do I now carry this through to my calculation text box or can I combine them to say.

1. Is this valid and if so, do calc. If not valid, say invalid and dont do calc.

 

[Chaz]

About to try something - can I embed this:

=DateDiff("d",[ACR_Submit_Date_Time],Now())

Into the IIF Statement?

 

[Chaz]

Ok, that seems to work - thank you kindly.

 

[namliam]

LOL @ Chaz, having a nice talk with your self?

Glad you worked it out, perhaps post the code for posterity?

 

[Chaz]

LOL @ Chaz, having a nice talk with your self?

Glad you worked it out, perhaps post the code for posterity?

Yep, I love talking to myself.

Let me practice some 'Netherlands'. Ja, ek hou daarvan om met myself te praat.

I changed the code a bit to look at another condition and use conditional formatting to colour the text box on the result of the number calculated.

Code (hardly):

=IIf([ACR_Submit_Date_Time] Is Not Null,DateDiff("d",[ACR_Submit_Date_Time],Now()),"N/A")