I see that my expression builder was trying autocorrect your expression (by putting MedWords into brackers). When I manually return yours to what you actually wrote, it does work.
Thanks so much.
Adelestrat
Last Activity: Sep 20 '14, 05:33 PM
Joined: Aug 29 '14
Location:
-
Thanks, NeoPa. That didn't work. As I mentioned in my second post, I finally found the right way to do it which was:
Code:IIf(IsNull([Grace]) Or [Grace]<#9/8/14#, "due 9/8/14", "valid through " & [Grace])
Leave a comment:
-
Never mind, I figured it out! It works when I wrote it this way:
Code:IIf(IsNull([Grace]) Or [Grace]<#9/8/14#, "due 9/8/14", "valid through " & [Grace])
Leave a comment:
-
Need Help Writing Query Expression that Includes IsNull Or with dates
I'm trying to have a query return "due by 9/8/14" if the entry in a field is blank or has a date before 9/8/14, or return "valid through (date)" if the date in the field is after 9/8/14. Here's how I've written the expression:
What am I doing wrong?Code:MedWords=IIf([Grace] IsNull Or <9/8/14, "due 9/8/14", "valid through [Grace]")
No activity results to display
Leave a comment: