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

"Rob W" <Whllrob@aol.com> wrote in message
news:%23o8DRiPiIHA.3780@TK2MSFTNGP06.phx.gbl...
> 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