Search results

first off thanks-- for putting in the simple comma-- i tired everything and for getting the status of completed-- i have been stumped at how i would actually go about getting the result-- essentially if the last review date is in the fiscal year (which runs Nov 1-Oct 31) then it is completed...

Okay Maybe i am totally confused but here is initially what i have and what i want to do. I currently have a db for carrer development-- i have three fields Last Review Date Next Discussion Due Status My next discussion due is on the fly-- i did a dateadd (by one year) from the last review...

Okay. so i got the next review date figured out-- my next question with the IIf function, is it possible to have more than two outcomes? i.e. our years go from Nov 1-Oct 31-- so if a review is done Nov 6/06, then the status would be complete-- as it is done for the fiscal year. The options i...

Good Morning :rolleyes: I have a complicated question here. I am currently building a db for career development in my workplace. The main fields that i am having some issues with is the following. I have three fields labelled as the following: 1) Last Review date 2) Next review date ( i...