Due Dates

[Hazel]

In my queries i have two fields

1st Field is called Termination Date
2nd Field is called Termination Notice-Due Date:

The Termination Notice-Due Date has an expression builder i.e.
Termination Notice - Due Date: [Termination Date]+28

This then gives me a Termination Notice - Due Date Automatically filled in using the above expression but it counts saturdays and sundays i dont want saturdays and sundays counted in the +28

Can this be done or iam i going nuts

please see attached this might help


Hazel

 

[trucktime]

Dates

Check this link.
The sample database you can download has what you need.

http://www.access-programmers.co.uk/forums/showthread.php?t=62570