Access version of Excel functions

[Lucky]

I am looking for corresponding Access function to replace
Excel functions WEEKNUM and NETWORKDAYS (from Add-Ins –
Analyst ToolPak). I currently call these functions from
Excel and use them in my queries. However, this slows the
query terribly (we are talking eternity here).

Would anybody know where to find Access version of these
function (WEEKNUM calculates the week number in a calendar
year, NETWORKDAYS returns the number of working days
between two dates)?

Thank you for your help.

Lucky

 

[Joan Wild]

Would anybody know where to find Access version of these
function (WEEKNUM calculates the week number in a calendar
year,

The DatePart function in Access will do this.

NETWORKDAYS returns the number of working days
between two dates)?

You'll find a function at
http://www.mvps.org/access/datetime/date0006.htm
for this.