Hi There!
So, the MS Access bug bit me big time and I am currently building a HR Recruitment Database for my Company. I am however not clever enough when it comes to building complicated formulas and are hoping that there will be someone to assist me.
I have:
A field called “DateonVAF” (This is the date when the vacancy was requested)
A field called “VAFStatus” (This indicated wether the vacancy is open, interviewing, filled e.g.)
What I want to do in the “NumberofDaysOpen” field is to calculate the days the VAF has been open between the current date and the “DateonVAF”
BUT here is my biggest snag …
I want to stop counting the number of days open once the status in the “VAFStatus” field has change to “Filled” and then that last value (final number of days) must stay unchanged in the “NumberofDaysOpen” field.
Hoping someone can assist 😊
Good Day
MS Access Newbie