weekend query

[Joel Allen]

Hi there,

I have a query that does:

[End Date] - [Start Date]

and it gives me a number of days. This works, but I want it exclude
Saturday and Sundays. Is there a way to do this?

Thanks so much for your help.
Joel

 

[Smartin]

Hi there,

I have a query that does:

[End Date] - [Start Date]

and it gives me a number of days. This works, but I want it exclude
Saturday and Sundays. Is there a way to do this?

Thanks so much for your help.
Joel

Hi Joel,

There are a number of solutions for this and related problems (e.g.,
excluding holidays, etc.) I suggest you google groups for

count exclude weekends access

and browse the results to see what works best for you.