How to find average score.<br><br>I have a table which inlcudes some values and I need to find their average score and print it in other table. How can I do it.
How to find average score.<br><br>I have a table which inlcudes some values and I need to find their average score and print it in other table. How can I do it.
create a query using the table and click on the totals button on the ribbon. That will add a row in the design that you can choose avg from the dropdown.
I don't know what printing the avg to another table means, unless you mean copy. If so, why?
You could do it making the query into an append or update query. But usually you don't put calculated data into tables, you calculate the value when necessary.
But I need to this work without query. Can I do avg function with calculated type?
Can you tell readers exactly what you are trying to accomplish?
Why would the answer be without a query??