Next Business Day Date Field

[Mary]

I need to set up a query that automatically adds the Date
for the next business day. Can someone help with the
proper code? I know Date()+1 equals the next day, but
I'll need it to pull Monday's date on Friday.

Thanks,
Mary

 

[Jon Spink]

Try:

IIf(Weekday(Date())=6,Date()+3,Date()+1)