Number of business days.

[Harmony]

I was given the following article to show how to calculate
the number of business days in Access. This shows the
coding, by question is, how do I get this figure into a
query to make calculations?

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

 

[Peter Doering]

I was given the following article to show how to calculate
the number of business days in Access. This shows the
coding, by question is, how do I get this figure into a
query to make calculations?

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

1. Copy the function into a module and save.
2. In a query in design view you type:
MyWorkDays: Work_Days(YourTable.YourStartDate, YourTable.YourEndDate)

HTH - Peter