checkbox as a condition

[Janjang]

i'm making form from query. but all i need to do is calculate days worked (TimeService) either worker still working or resigned.

i want to know is it possible to make it condition like it to query? if not can u tell me the other way?

 

[ansentry]

See attached database.

Changes made to query and a new form created.

Have a look in help for DateDiff and DateAdd, they are both easy to use.

 

[Janjang]

nice..thanks
but how to make it calculate depend on checkbox?

like this:
Current date - Hired date, when check box not checked
Resinged date - Hired Date, when check box was checked..

any here have an idea?