Functions call in a query

[samcoinc]

I have a function that is getting called from a query. It has grown over the years as I am passing more and more variables to it. Is there a limit to the number of variables that can be passed to a fuction in a query? I have added 1 more varaible and now I get "the expression you entered is too complex" It isn't 255 characters long - (I have run in to that before) it does have around 30 variables.

It works if I call the function in VB

This is access 97

sam

 

[samcoinc]

Doing more searches - seems the limit is around 30 variables that you can pass to a function in a query...

We are getting by concatinating/delimiting some of the text fields that get sent.

 

[Rx_]

Access 97 brings back some old memories!

255 characters is a big limit in several Access areas. You might notice that queries don't get parsed in the Query window SQL view when they grow large. It would seem time to re-design the function that has grown organically over time.

It is acceptable to have functions inside of functions.
If a group of parameters can be grouped together to return a single value that is used in the outer function; the query could use two functions - but hide the result of the sub function.