Dynamic weekday total for any given month

[asheer]

I have a report grouped by months, and in the date group header, I want to
reflect the total number of available weekdays in that month. I can't use a
parameter query because there are multiple months in my report. It needs to
be something like if month is September, then available weekdays = 21.

Anyone know how to make this work?

 

[Clifford Bass]

Hi,

One way would be to use the On Format event of the group header and
count the number of weekdays in the current month. You can use the Weekday()
function. Then assign the result to your weekday count text box. Since it
can vary from year to year, you will need to take the year into consideration.

Clifford Bass

 

[Jeff Boyce]

Won't that depend on which holidays are being celebrated (and deducted from
the total number of available workdays)?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[asheer]

I will back out the holidays from the total number of weekdays after the
fact. I'll try your suggestion Clifford. Thanks.

 

[Clifford Bass]

Hi,

You are welcome. Good Luck!

Clifford Bass

I will back out the holidays from the total number of weekdays after the
fact. I'll try your suggestion Clifford. Thanks.