Sum Avg not working

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
 
M

Marshall Barton

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.
 
Top