>I'm looking for a formula. Assuming I have a rate of 1, 2, 3, 4, and 5. I then have 2 results for 3 and 2 results for 5. This would then give 4.00 as the rating result I am looking for. I'm looking for the formula which would give that rating.

select sum(Rate*Num) as TotalSum, sum(Num) as TotalNum from yourtable into cursor curResult

RatingResult=curResult.TotalSum/curResult.TotalNum

Fourth update :)