Ratings System

R

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
 
A

Amy Blankenship

Rob W said:
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.
Click to expand...

Select Avg(YourColumn) As YourColumnAvg FROM YourTable.

HTH;

Amy
 
Top