Avg function

[robbydogg]

Hello,
I think i've got friday dimness, but can you help / slap my brain into gear with this AVG function?
I'm trying to average certain values (in a query) but can;t remember how to ge tit working.

What i need is an average of coulmns 10 11 and 12

I put in =AVG([10],[11],[12]) but no luck.

Please prove my thickness


Thanks
Rob

 

[wiremonkey22]

U could just use the totals button at the top of the query design looks like an E change the totals row above criteria to AVG sorry if im way off of what your trying to do may need more info like where your putting this expression what are the field names etc.....

 

[robbydogg]

hi. thanks for the reply. a colleague just gave me the answer - then looked at me like i'm a complete donut. never mind