working days Code

[amal1973]

Hello...
I have been looking around to understand how to enter a starting date and an ending date in a form ,and to have the result in another textbox..I do not want to calculate weekends or holidays.
I have created a database from five feilds
date(pk) ,hoilday_name, startdate as date ,ending date as date, total days as number ..
please advice me what to do next , i dont have that much knowledge with vba..
thanks

 

[JoeMiller]

Date/Time: Calculate Number of Working Days

http://www.mvps.org/access/datetime/date0006.htm

-OR-

Date/Time: Doing WorkDay Math in VBA

http://www.mvps.org/access/datetime/date0012.htm

HTH Joe Miller
joe.miller@flotech.net

 

[MichaelRed]

or just faq181-261 right here in Tek-Tips

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over