Call a Function from a Query

[LarryDeLaruelle]

Is it possible to call a function from a query?<br><br>I need to categorize a lengthy list of codes into common groups for cross tabs and thought a function would be the best way to go for several reasons, especially the probable need to reuse the code in other queries.<br><br>Every time I have tried to do this I get an undefined function message.<br><br>Any idea what I may be doing wrong? <p>Larry De Laruelle<br><a href=mailto:larry1de@yahoo.com>larry1de@yahoo.com</a><br><a href= > </a><br>

 

[jimmythegeek]

Do you have the following syntax?<br><br>=FunctionName()<br><br>Also, make sure it is not a sub in the module, and that the function is public.<br> <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href=

http://www.cgeek.com>CompuGEEKS</a><br>Custom

Application Development

 

[LarryDeLaruelle]

Thanks Jim:<br><br>I think I figured out my problem.&nbsp;&nbsp;I had named the module and the function the same name.&nbsp;&nbsp;Once I corrected that it now works fine.<br><br>This is a neat feature that will save me a ton of time. <p>Larry De Laruelle<br><a href=mailto:larry1de@yahoo.com>larry1de@yahoo.com</a><br><a href= > </a><br>