Calculating working days between 2 dates 1

[KevinNewtoAccess]

I have a table with 3 fields
Field 1 - start date
Field 2 - end date
Field 3 - working days between start & end dates.

Fields 1 & 2 are populated & I need to populate field 3. This to show number of days between start & end dates excluding weekends & any other national holiday dates.

Any suggestions to point me in the right direction would be appreciated.

Thanks
Kevin.

 

[MichaelRed]

Go Here. See This. Follow Directions.

http://tek-tips.com/faqs.cfm?spid=1...id=261&CFID=10888031&CFTOKEN=91869671

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[KevinNewtoAccess]

Thanks for the pointer Michael - looks like this should be exactly what I need.

However, I am having a problem with the code :-

I have copied the code into a module and have set up the holiday table. When I try to use the Deltadays function I get the following visual basic error

"User defined type not defined" with a highlight on the line
Dim dbs as Database

I am sure this is a simple lack of understanding on my part but, at the moment my learning curve with Access seems to be pretty well vertical!

Rgds
Kevin