Hello,<br>I try to use the Avg function in a query with the expression generator.<br>I want to obtain in a new field, the average of several field.<br>Thanks for your reply.
Hello,<br>I need to obtain the average of fields which have the same scale and I want that Access recognise that some cases are blank. For a record, it is possible that a field is blank and I want that Access calculate without this field for this record only.<br>Best regard.<br>Polo
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.