networkdays equivalent in Access

[toon10]

Hi

I have an Access project which links to SQL tables. I'm using various queries to give me information.

I've been asked to produce some extrapolated figures. I need to basically take a number from my query (i.e. it may be 20) and then extrapolate that over the month using working days.

This is worked out by calculating the working days between today’s date (from 1st working day) to today. Divide a number in my query by this figure to get average for 1 day. Multiply this by the total of working days in month.

So if we take the figure 20 and we are currently 10 working days into the month, which consists of 24 working days then…

…20 / 10 = 2 (2 is the average number in 10 working days)
Multiply this by 24 = an extrapolated figure of 48

Has anyone ever produced a similar query with extrapolated figures using a working days function? I no Excel has the (networkdays) function but does Access have a similar one?

Thanks in advance
Andrew

 

[MichaelRed]

see faq181-261 The Excel function in Ms. A. is not imcluded in Ms. A. VBA. The FAQ is one workaround, which includes the benefit (?) of being able to also account for Holiday dates. Inclusion of the Excel Library in your app/project is another.





MichaelRed

 

[toon10]

OK Thanks, I'll look into that

 

[DoctorV3774]

Check out this code right here posted on UtterAccess.com. This will work for NetworkDays skipping Saturdays, Sundays and Company Holidays

http://www.utteraccess.com/forums/s...=368429&page=1&view=collapsed&sb=5&o=&fpart=1