Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculating working days between 2 dates 1

Status
Not open for further replies.

KevinNewtoAccess

Technical User
Dec 7, 2000
13
GB
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top