I cannot find a function for an expression where I want to change a short date (e.g., 11/22/01) to the long month (i.e., "November"). If you use Month ([datefield]), you get "11", not "November". VBA has a "Monthname" function that will do this. Is there an equivalent function for expressions?
Failing this, I will have to write a VERY long nested iif's expression (i.e., iif(month([datefield])=1, "January", iif([month([datefield])=2, "February", iif...)))))))))))). Not even sure that's possible, because my recollection is that Access has a limit on nested iif's, and I think it's 8...which is not enough.
Failing this, I will have to write a VERY long nested iif's expression (i.e., iif(month([datefield])=1, "January", iif([month([datefield])=2, "February", iif...)))))))))))). Not even sure that's possible, because my recollection is that Access has a limit on nested iif's, and I think it's 8...which is not enough.