V
vy
I need help calculating Network Days in Access 2003. The formula I use in
Excel is
= (Monthly Quota/NETWORKDAYS (Beginning of Month, End of Month))*NETWORKDAYS
(Beginning of Month, TODAY ()-1)
The Beginning of the Month and End of Month I pull from a column with just
those two dates for the month. And then each month I change the month and
Days.
How can I calculate Network days in Access? I do I put this in code? If so
how (Because I don't know) and do I manually put the dates in the query
fields or will the calculate some how? Please help.
Excel is
= (Monthly Quota/NETWORKDAYS (Beginning of Month, End of Month))*NETWORKDAYS
(Beginning of Month, TODAY ()-1)
The Beginning of the Month and End of Month I pull from a column with just
those two dates for the month. And then each month I change the month and
Days.
How can I calculate Network days in Access? I do I put this in code? If so
how (Because I don't know) and do I manually put the dates in the query
fields or will the calculate some how? Please help.