Not Counting Weekends

[Guest]

I would like to create a program that logs and fills out my vacation slips
for me. I work M-F/8-5. Is there a way to have Access not count weekends?
If I put in a slip on Wednesday at 3pm for 40 hrs, can Access be taught that
my vacation ends the following Tuesday at 3pm?

Thanks In Advance
Wm.

 

[news.microsoft.com]

In a word yes. It's just a matter of simple logic.
(I have a function to do this but despite hunting for a good 30mins cannot
locate it sorry)

Use Weekday, Day and DateDiff functions as appropriate

Count the number of 24hrs in the vacation period add these on from the start
time
Check for the presence of W/E days and push forward the end result as
required.

Sorry I cannot supply the code just now deadline passed!


"open a adobe file from a command button"

 

[news.microsoft.com]

Just came across this whilst looking up something else.


http://www.accessmvp.com/DJSteele/SmartAccess.html

look for

September 2004: Working all day (319 KB)
Calculating Working Days