And Operator in TruePart section of an IIf statement
Posted on 2010-09-13
I'm currently trying to figure out how to produce a query in MS Access that says "if today is Monday then look for data within a 24hr period, 4 days in the future"
The query that I've been working on appears to work when sperated down but not as a whole. After much searching I found this might be because it is not possible to use the 'AND' operator in the TruePart of an IIf statement.
Does anybody know of a way round this? I'm no expert in MS Access so the simpler the better!
iif(WeekDay(date())=2,>Format(Date()+4,"yyyymmdd") & "0000" And <Format(Date()+4,"yyyymmdd") & "2400","")
Thanks in anticipation,