User Defined Functions

[Tom Waters]

Hi

Is it possible to write a UDF that gains its results from an Access
database?

I can find plenty of examples of how to connect and run queries of an access
database but I can't find anything that anyting that shows how a UDF can be
used.

Thanks

Tom

 

[Tom Waters]

I guess I wan't the udf to run the query as the where statement is based on
the input parameters.

Once the UDF's are created they will be used in many instances in the file
and therefore I need to minimize the time the file takes to calculate