Access due dates

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

"Sue at WaMu" wrote in message
...
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!