Weekdays...

[bodylojohn]

Hello everyone..

First of all...I am really thankfull for this Forum.

I have a Question

I have 2 dates. FromDate and ToDate

I want to Calculate the days without the weekdays.

Please help..

Thank you very much in advance...

 

[Malcy]

Hi
Probably an easier way but first thought would be to get the day of the week - use DatePart - for the intervening days and then add up those days with values 1 (Sunday) and 7 (Saturday)
Any help?
I suspect there is a better way but this might get you started.
Good luck

 

[Bat17]

check out this thread
http://www.access-programmers.co.uk/forums/showthread.php?t=94553&highlight=workdays

Peter

 

[Bat17]

looks like I got it back-to-front, try this one
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51941&highlight=dates

Peter

 

[bodylojohn]

Hi guys..

Thanks for your solution so far.
But I want to do it in a query.

Please help.

Can I also deduct the holidays????

PLEASE Help me..
And thanks in advance