>Thanks. I tried this. The name of my table is in fact ratings
>
>

>select [hour], avg(mRating) as AvgRating from Ratings GROUP BY [hour]
>

>
>But I don't get an average for every hour, instead I got an average for the entire table, in other words a table with a single record?
>
>

>exp_1     AvgRating
>hour       3.64
>

>
>Have any ideas?
>Thanks
>Steve

That SELECT is Sql Server syntax. The brackets are used because hour is a keyword. In VFP syntax, the brackets are a string delimiter, making you select the string "hour". Try it again without the brackets.