Undefined Function

I've written a custome function which I would like to use in a query. The
function take the value of three fields and reports back a calculated
result. This works fine, however, just recently it has been reporting as an
Undefined Function when I try to run the query. Is there a way to
explicitly force the function to be recognised?? As I said it was working
fine, and now I am getting this new error.

g

re: Undefined Function

Gargamil,

Try the following:

1. Move the function into a module,
2. Declare the function explicitly as 'Public',
3. Recompile,
4. Repair and compact,
5. Test.

Cheers,

Mike

Gargamil wrote:[color=blue]
> I've written a custome function which I would like to use in a query.[/color]
The[color=blue]
> function take the value of three fields and reports back a calculated[/color]
[color=blue]
> result. This works fine, however, just recently it has been[/color]
reporting as an[color=blue]
> Undefined Function when I try to run the query. Is there a way to
> explicitly force the function to be recognised?? As I said it was[/color]
working[color=blue]
> fine, and now I am getting this new error.
>
> g[/color]