What is #Func! error message for in access? How to fix it?

Hi Farhana,

The #Func! error message in Access indicates that there is an error with a custom function used in a query or form. This error typically occurs when Access cannot find or execute the function.

In your case, since the error is occurring for vendors with only one invoice with an amount of 0, it is possible that the custom function is not designed to handle this scenario correctly.

You will have to modify the function so that it can handle this scenario correctly.

To fix this issue, you can try the following-

1. Debug the function
2. Check the Function References are correct and that all necessary libraries and references are available.
3. Check the function parameters are correct and that the function is being called correctly in the query or form.

Best Regards.

Hi Farhana,

The #Func! error message in Access indicates that there is an error with a custom function used in a query or form. This error typically occurs when Access cannot find or execute the function.

In your case, since the error is occurring for vendors with only one invoice with an amount of 0, it is possible that the custom function is not designed to handle this scenario correctly.

You will have to modify the function so that it can handle this scenario correctly.

To fix this issue, you can try the following-

1. Debug the function
2. Check the Function References are correct and that all necessary libraries and references are available.
3. Check the function parameters are correct and that the function is being called correctly in the query or form.

Best Regards.

there's no error with the formula.

There is an error in the formular, otherwise you wouldn't get #func.

You mentioned value 0, so may be a "Division by Zero" error.