How to use the Average function in a query?

[Polo8]

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.

 

[justtrying]

Try this ([Field1]+[Field2]+[Field3])/3

 

[samara]

i think you can use this syntax...<br>newField: AVG([Field1]+[Field2]+....)<br><br>Hope this will help YOU, <p>Mohamed Aly<br><a href=mailto:samara_79@hotmail.com>samara_79@hotmail.com</a><br><a href= > </a><br>