Hi all,

Is there a number of fields limitation when doing Avg() in Access 2000?
I tried to select average values for each of the 150 columns the same time, however, I received an error msg "Too many fields defined".

My sql is like this:

select code, avg(col1), avg(col2),...,avg(col149), avg(col150)
from table1
group by code

I have tried to do sum() instead of avg(), surprisingly, sum() works fine!! They are both aggregate functions. Why one work and not the other?

Please help. Thanks.