Product rating for webshop - Average??

[btn]

Hi - using ASP/ACCESS/VBscript

Working on a product rating feedback service for products in my webshop.
Have created a DB table called productrating to store all the info.
Customers can rate products from 1 (poor) - to - 5 (best).
The rating goes in a number field, and the ProductID is collected for each
product. So far so good.

Ned an advice on how to display the average rating for each product as there
could be several feedbacks on each product.

Any suggestions?

Bjorn.

[Manuel Socarras]

you can try AVG clause, something like this:

"SELECT product, AVG(rating) FROM productrating GROUP BY product"

HTH,

manuel

btn wrote:

> Hi - using ASP/ACCESS/VBscript
>
> Working on a product rating feedback service for products in my webshop.
> Have created a DB table called productrating to store all the info.
> Customers can rate products from 1 (poor) - to - 5 (best).
> The rating goes in a number field, and the ProductID is collected for each
> product. So far so good.
>
> Ned an advice on how to display the average rating for each product as there
> could be several feedbacks on each product.
>
> Any suggestions?
>
> Bjorn.
>
>