Access due dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

designing query for "off calendar"; have due date expressions working
correctly - time frame is within one month, so need to add to expression that
due dates cannot be Sat or Sun ( have tried inserting (iif("d"=Sat, +2)) and
get same due date which actually is the Sat 1/28) and suggestions would be
appreciated!
 
Sue

Take a look at Access HELP on the IIF() function.

And I'm not sure where you picked up the expression {"d"=Sat}, but I don't
believe Access will know what you mean by that. Take a look in Access HELP
at the Weekday() and WeekdayName() functions -- they may be more what you're
looking for.

Regards

Jeff Boyce
<Office/Access MVP>
 
Back
Top