If I have 2 date columns and I want to calculate the number of BUSINESS days
that has passed between them, how can I do that?

Have a look here:
http://www.mvps.org/access/datetime/date0006.htm
http://www.mvps.org/access/datetime/date0012.htm

-Michael


"KBV" wrote:

> If I have 2 date columns and I want to calculate the number of BUSINESS days
> that has passed between them, how can I do that?
>
>

I'm new to access, can I just put the function directly in design view or
does this require me using VBA code...

Pls advise.


"Michael H" wrote:

> Have a look here:
> http://www.mvps.org/access/datetime/date0006.htm
> http://www.mvps.org/access/datetime/date0012.htm
>
> -Michael
>
>
> "KBV" wrote:
>
> > If I have 2 date columns and I want to calculate the number of BUSINESS days
> > that has passed between them, how can I do that?
> >
> >

The functions are VBA code, but they are already written for you. All you
have to do is paste the functions you want to use into a new Module, then use
them wherever you want to calculate workdays, whether that's a field in a
Query, or a control on a Form or Report. You can also use them in any other
VBA code you may write yourself.

-Michael



"KBV" wrote:

> I'm new to access, can I just put the function directly in design view or
> does this require me using VBA code...
>
> Pls advise.
>
>
> "Michael H" wrote:
>
> > Have a look here:
> > http://www.mvps.org/access/datetime/date0006.htm
> > http://www.mvps.org/access/datetime/date0012.htm
> >
> > -Michael
> >
> >
> > "KBV" wrote:
> >
> > > If I have 2 date columns and I want to calculate the number of BUSINESS days
> > > that has passed between them, how can I do that?
> > >
> > >