By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,500 Members | 830 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,500 IT Pros & Developers. It's quick & easy.

Networkdays

P: n/a
Hi all,

In excel you can use a command to calculate the number
of days between two dates, taking into account holidays
and weekends. I.e. number of 'working days'.

How can this be done in MS access as the command is
not available. If it is done using a module, please explain
how to use the module within the database. I can design
databases ok and can generally understand the code used
in modules, but I am not always sure how to link the module
to the form or table etc. Please advise.

Many thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Check the Date section of "The Access Web" http://www.mvps.org/access/ for a
couple of different approaches.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

"Charles Spencer" <ca*@freenet.co.uk> wrote in message
news:bu**********@news6.svr.pol.co.uk...
Hi all,

In excel you can use a command to calculate the number
of days between two dates, taking into account holidays
and weekends. I.e. number of 'working days'.

How can this be done in MS access as the command is
not available. If it is done using a module, please explain
how to use the module within the database. I can design
databases ok and can generally understand the code used
in modules, but I am not always sure how to link the module
to the form or table etc. Please advise.

Many thanks.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.