wildcherry98
MIS
Okay Here goes..
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 have this entered in as an auto generated date-- will add one year from the last review date)
3) Status
I have everything worked out except for the status field. Our year goes from nov 1-oct 31. So these are the options that i want to show up--
overdue-- if not completed in the fiscal year
completed-- if done in fiscal year
upcoming-- booked for a date within the fiscal year.
Here is my formuls so far::
Status:Iif([LastReviewDate]>=#11/1/2006# And ([LastReviewDate]<=#10/31/2007#,"Complete", IIf([Next Discussion Due]<Date(),"OverDue",IIf([Next Discussion Due]>Date(),"UpComing")))
When I try to close access i get the following error:
The expression you entered is missing a closing parenthesis bracket or vertical bar--
i cannot seem to fix this--
does anyone have any ideas??
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 have this entered in as an auto generated date-- will add one year from the last review date)
3) Status
I have everything worked out except for the status field. Our year goes from nov 1-oct 31. So these are the options that i want to show up--
overdue-- if not completed in the fiscal year
completed-- if done in fiscal year
upcoming-- booked for a date within the fiscal year.
Here is my formuls so far::
Status:Iif([LastReviewDate]>=#11/1/2006# And ([LastReviewDate]<=#10/31/2007#,"Complete", IIf([Next Discussion Due]<Date(),"OverDue",IIf([Next Discussion Due]>Date(),"UpComing")))
When I try to close access i get the following error:
The expression you entered is missing a closing parenthesis bracket or vertical bar--
i cannot seem to fix this--
does anyone have any ideas??