Ratings System

[Rob W]

Greetings,

This is more of a logic question than perhaps access but has anyone made a
ratings system or would know the logic behind it?

E.g.

I have a form where a user can select a drop down box containing values of
say 1-5 it would then calculate the average everytime another user selected
a value.

Any tips or advice would be appreaciated

Cheers
Rob

 

[Amy Blankenship]

Greetings,

This is more of a logic question than perhaps access but has anyone made a
ratings system or would know the logic behind it?

E.g.

I have a form where a user can select a drop down box containing values of
say 1-5 it would then calculate the average everytime another user
selected a value.

Select Avg(YourColumn) As YourColumnAvg FROM YourTable.

HTH;

Amy