Converting NETWORKDAYS

[Jackie]

Hi
i need to convert a function in an excel spreasheet into access using a
query.

NETWORKDAYS is the function. Does anyone know the equivelent in Access.
Thanks in advance.

 

[kc-mass]

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

Save one of these function in a new module in your db. You can then use it
like a built in
function.
"Workdays" will give you the number of days between two dates (less
weekends).
"Workdays2" will give you the number of days between two dates (less
weekends and holidays)

User them in a query like MyWorkDays: Workdays2(StartDate, EndDate)

Regards

Kevin

 

[Daniel Pineault]

Such a function does not exist in Access. The good news is you are not the
first to require to do such work and people have already created similar
functions.

Take a look at : (specifically the dhCountWorkdaysA function)
http://www.mvps.org/access/datetime/date0012.htm

More generaly:
http://www.mvps.org/access/datetime/index.html

--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Al Campagna]

Jackie,
On my website (below) I have an Access Tips sample zip file for
Access 97 and/or Access 2003... called Calculate Number of Workdays

It utilizes a Holiday table that you populate with your own holidays
and business closed dates, and it calculates the number of workdays
between any two dates.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."