Sum Avg not working

  • Thread starter Thread starter TK
  • Start date Start date
T

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
 
TK said:
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.
Click to expand...


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