Undefined function

[Hammond-Wandsworth]

I'm trying to use the WORKDAY function within a query. If the query returns a
warning box when I try to run the query that says 'Undefined function
'WORKDAY' in expression' does that mean my Access does not have that function
within it's capability? I can't work out why it's not working. The syntax I'm
using is: Expr10: WORKDAY([Date Adopted],14) - I do not need to include
holidays so I have left that part of the function off. Could that be the
problem. Please help. Thanks.

 

[Jerry Whittle]

Access doesn't have a Workday function; however, Excel does and you can use
it in Access. Check this out:

http://www.dbforums.com/archive/index.php/t-320731.html

 

[John W. Vinson]

does that mean my Access does not have that function

Correct. That's an Excel function, not an Access function.

See http://www.mvps.org/access/datetime/date0012.htm for some sample code to
incorporate workday math.

John W. Vinson [MVP]

 

[Hammond-Wandsworth]

Thank you both. Much appreciated.

Correct. That's an Excel function, not an Access function.

See http://www.mvps.org/access/datetime/date0012.htm for some sample code to
incorporate workday math.

John W. Vinson [MVP]