Networkdays

[Charles Spencer]

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.

[Douglas J. Steele]

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.