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)
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?