Function/SP results in Query

[Chris B]

I would like to know how to have the results of a VB
function in Access populate a field in a query.

For example, the query will select data for a [Start
Date] field and an [End Date] field. I would like the
function to populate a third field with the number of
business days between the two dates based on a
predetermined business week.

The function works fine in the query from within Access,
but when I try to use the same query in an ADODC from
within a VB app, I get an error saying that the function
is unidentified. I even tried using
"module1.functionname()".

the full test query is:
SELECT Data.Appt_Date AS StartDate,
Data.Delivered_Date AS EndDate,
numbusdays([StartDate],[EndDate],[Work Week Enum].
[expr1]) AS [Business Days]
FROM Data, [Work Week Enum]
WHERE ((("Appt_Date") Is Not Null)
AND (("Delivered_Date") Is Not Null));

What am I doing wrong ?

Thanks, Chris