STOP DateDiff function

[KMEscherich]

Using Access '97

Hi there. I have a field that uses a DateDiff function to count the number of days between a DATE field and DATE(), is there a way to have the counter stop counting days when the FINISHED checkbox has been selected??

=DateDiff("d",[DateReported],Date()) & " DAYS HAVE PASSED SINCE THE SRI SUBMITTED DATE"

Thank you in advance for your assistance.

K_Escherich

[JConsulting]

Using Access '97

Hi there. I have a field that uses a DateDiff function to count the number of days between a DATE field and DATE(), is there a way to have the counter stop counting days when the FINISHED checkbox has been selected??

=DateDiff("d",[DateReported],Date()) & " DAYS HAVE PASSED SINCE THE SRI SUBMITTED DATE"

Thank you in advance for your assistance.

K_Escherich

let's see

=iif([yourcheckbox],"Times Up",DateDiff("d",[DateReported],Date()) & "  DAYS HAVE PASSED SINCE THE SRI SUBMITTED DATE")