Avg calculated fields

[Guest_imported]

My module has a function that's receiving an array of multiple fields, from a query.A field in my query is calling the function.I need to get the average of this calculated field to display in the report.But it keeps giving me &quot;Jet doesn't recognized SQL statement, some field has invalid data type&quot;The calculated field is integer type.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.I need to use the function though.<br>Thanks,