I have a query in my Access database that has a complex calculation for
one of the calculated fields. I wrote the function in VBA code and it runs
fine in Access; but my application is a VB6 appilcation. When I try to run
the query either by the query name or by copying the SQL, I get an error
that says it can't find my function. I moved a copy of the function into
VB6 but the query still can't find the function. Any Ideas how to make this
work?