Prev: can't open the report in the design view
Next: Cannot open the Access 2007 database
From: Simon on 11 Mar 2010 14:43
I would like to count the number of working days between two date,
For example a date on a Friday and a date on the following Monday will
count as 1 Day not 3 Days

Is there a way to do this in an query

Thanks
From: Dirk Goldgar on 11 Mar 2010 14:45
"Simon" <S.Dickson(a)shos.co.uk> wrote in message
news:405c914a-bb14-4df6-b992-41aefc5643ff(a)k17g2000yqb.googlegroups.com...
>I would like to count the number of working days between two date,
> For example a date on a Friday and a date on the following Monday will
> count as 1 Day not 3 Days
>
> Is there a way to do this in an query


You need to use a VBA function to do it. Here are some functions to do
"workday math":

http://www.mvps.org/access/datetime/date0012.htm


--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

From: De Jager on 13 Mar 2010 12:25

"Simon" <S.Dickson(a)shos.co.uk> wrote in message
news:405c914a-bb14-4df6-b992-41aefc5643ff(a)k17g2000yqb.googlegroups.com...
>I would like to count the number of working days between two date,
> For example a date on a Friday and a date on the following Monday will
> count as 1 Day not 3 Days
>
> Is there a way to do this in an query
>
> Thanks

 | 
Pages: 1
Prev: can't open the report in the design view
Next: Cannot open the Access 2007 database