working dates!

[victoriathomson]

Hi! I'm not a very advanced computer user but am trying to make
library system! I'm trying to work out how to calculate the day a boo
is due back. The books have to be returned one calendar month afte
they are taken out but if this due date falls on a weekend then the du
date is changed to a monday! can anybody help?! I'd be very grateful i
you would post a reply,
Thank you so much,
Vicki

 

[victoriathomson]

sorry, i forgot to mention im using microsoft access 2000

 

[Steve Schapel]

Vicki,

In a query, you can make a calculated field along these lines...
DueDate:
DateAdd("m",1,[DateOut])+IIf(Weekday(DateAdd("m",1,[DateOut]),2)>5,8-Weekday(DateAdd("m",1,[DateOut]),2),0)