Edited
This works. Unfortunately, I am defeated on where to put separator.
=IIF(Format(Now(), "mmmm")="JANUARY", "TERM ONE",""),=IIF(Format(Now(), "mmmm")="FEBRUARY", "TERM ONE",""),=IIF(Format(Now(), "mmmm")="MARCH", "TERM ONE",""),=IIF(Format(Now(), "mmmm")="APRIL", "TERM ONE",""),=IIF(Format(Now(), "mmmm")="MAY", "TERM TWO",""),=IIF(Format(Now(), "mmmm")="JUNE", "TERM TWO",""),=IIF(Format(Now(), "mmmm")="JULY", "TERM TWO",""),=IIF(Format(Now(), "mmmm")="AUGUST", "TERM TWO",""),=IIF(Format(Now(), "mmmm")="SEPTEMBER", "TERM THREE",""),=IIF(Format(Now(), "mmmm")="OCTOBER", "TERM THREE",""),=IIF(Format(Now(), "mmmm")="NOVEMBER", "TERM THREE",""),=IIF(Format(Now(), "mmmm")="OCTOBER", "TERM TWO","")
Edited
This works. Unfortunately, I am defeated on where to put separator.
=IIF(Format(Now(),
"mmmm")="JANUARY", "TERM ONE",""),=IIF(Format(Now(),
"mmmm")="FEBRUARY", "TERM ONE",""),=IIF(Format(Now(),
"mmmm")="MARCH", "TERM ONE",""),=IIF(Format(Now(), "mmmm")="APRIL", "TERM ONE",""),=IIF(Format(Now(),
"mmmm")="MAY", "TERM TWO",""),=IIF(Format(Now(),
"mmmm")="JUNE", "TERM TWO",""),=IIF(Format(Now(),
"mmmm")="JULY", "TERM TWO",""),=IIF(Format(Now(),
"mmmm")="AUGUST", "TERM TWO",""),=IIF(Format(Now(),
"mmmm")="SEPTEMBER", "TERM THREE",""),=IIF(Format(Now(),
"mmmm")="OCTOBER", "TERM THREE",""),=IIF(Format(Now(),
"mmmm")="NOVEMBER", "TERM THREE",""),=IIF(Format(Now(),
"mmmm")="DECEMBER", "TERM THREE","")
Somebody to assist where to put separators. I am still new in access