Averages for Duplicate Cells

[Alex19nz]

Right, So i've got a table which has records for the Top 40 Music Charts.

I want to be able to find out the averages for each song taken from it's positions in the chart over the weeks:

So essentially I get something that tells me

[Lenny Kravits] [American Woman] [24.5]
[Silverchair] [Ana's Song (Open Fire)] [41.1]

and so on...

Any ideas?

Cheers guys,
Alex.

 

[pbaldy]

How about a "totals" query grouping on title and artist, and averaging position?

 

[Alex19nz]

yeh that sounds good.. how do I do that?

 

[Alex19nz]

the chart is here:

Charts.mdb

 

[pbaldy]

Create a query with those 3 fields. Click on the icon that looks like an "E", or View/Totals from the menu. That will give you a new row in the design grid called Total, and probably all 3 fields say "Group By". Change the Position field to say "Avg" and run the query.

 

[Alex19nz]

Cracker!

Cheers Paul