How obtain average with different columns but some blank cases

[Polo8]

Hello,<br>I have to obtain the average of columns, but some cases are blank. The blank case can be in each column.<br>I want that Access recognise that the case is blank and calculate the average without this blank column.<br><br>Best regards.<br>Polo

 

[DougP]

Ok lession 1 in Access<br>Columns run up and down rows go accross left to right.<br>Columns are called fields and rows are called records <br>Rewrite your question using this so we know what you are talking about.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Guest_imported]

if you use the AVG() it will exclude NULL fields if the field contains 0 it will include that field in the average

 

[Polo8]

Ok, it is good that it exclude Null field. I know how to add some field and divide by a fix number (with the expression generator), but I don't know how to let Access do autmonatically the Average, without add and divide.<br>Let me know, thanks.<br>Polo

 

[Guest_imported]

on a report<br>=avg([yourfieldnamehere])<br>in a text box<br>in a query <br>click on the totals button then in the total on field you a want to average select Avg