Access-networkingdays

[jenmc]

Does any body understand how to use the networkingdays function?

 

[THoey]

It is not a function of Access 97, at least I couldn't find it in help. Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[nickjar2]

this won't be any help but I tried to use this function the other day but i kept getting an error (as though the function doesn't exist. I am using 2000.

 

[tlbroadbent]

I'm not aware of a function by that name in Access. Excel has a function called NetWorkDays but I cannot get it to work in Excel. Check MichaelRed's FAQ (faq181-261) for a way to calculate working days. Terry

http://members.home.net/tlbroadbent/prog.htm

"I'm not dumb. I just have a command of throughly useless information." - Calvin, of Calvin and Hobbes

 

[WingandaPrayer]

This link also has an example attached that simulates the Excel Networkday function in Access

http://www.athree.com/cgi-bin/discu...se&Searchpage=0&Limit=25&Old=1year&Main=55248

David

 

[WingandaPrayer]

Footnote to the above(if that is possible)


The final line should read

funWorkDaysDifference = (lngTotalDays - lngTotalHolidays) - 1


unless you want to count your start date in the calculation.

David