Sum Avg not working

[TK]

I have a strange occurence. In a class module I get an error when I try to
use the Sum or Avg functions. The error tells me the "Sub or Function not
defined" error. I have checked my references and don't see anything missing,
and these function are used in a Public Function in another module.
Any ideas?
TK

 

[Marshall Barton]

I have a strange occurence. In a class module I get an error when I try to
use the Sum or Avg functions. The error tells me the "Sub or Function not
defined" error. I have checked my references and don't see anything missing,
and these function are used in a Public Function in another module.

Those are SQL Aggregate functions. They are not available
in VBA code.