Average Query

[Lorlai]

I need to create an average query that will average the values from three columns, jan, feb, mar. I'm having problems coming up with the syntax. Does anyone know how I could properly do this?

Thank you!

[Lorlai]

I was finally able to find what I needed:

Qtr1: (nz([Nov],0)+nz([Dec],0)+nz([Jan],0))/3

Just out of curiosity, does anyone know what the "nz" means?

[alansidman]

http://www.techonthenet.com/access/f...dvanced/nz.php

[Lorlai]

Perfect, thank you!