Avg calculated fields

[Guest_imported]

My module has a function that's receiving an array of multiple fields, from a query.&nbsp;&nbsp;A field in my query is calling the function.&nbsp;&nbsp;I need to get the average of this calculated field to display in the report.&nbsp;&nbsp;But it keeps giving me &quot;Jet doesn't recognized SQL statement, some field has invalid data type&quot;&nbsp;&nbsp;The calculated field is integer type.&nbsp;&nbsp;Instead of calling a function, and just having <br>Field: ([a] + <b>)...there would be no problem when i try to get the average of it.&nbsp;&nbsp;I need to use the function though.&nbsp;&nbsp;<br>Thanks,

 

[jimmythegeek]

Copy your function here, and tell us what is bombing. <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