[SOLVED] How Do I Make A Summary Query On One Field?
Posted: Mon Jul 09, 2018 9:30 pm
I used to do this in Microsoft Access many years ago but don't own it anymore and even though OO seems to be the same functions, I have forgotten how to do this.
Here is my table
Song Name
Music
Lyrics
Performance
Mix
Commercial Appeal
Album Name
Year
I have a query that adds (Music + Lyrics + Performance + Mix + Commercial Appeal) and then divides by 5 to get an average for each record. That works fine.
What I want is to create a query that will get an average for each album. So I know that the first thing I have to do is add up all the sums for each album and then compute the average.
So let's say I have 5 songs in an album named Album 1 and these are their average scores.
75
82
90
78
86
I want to be able to add up all those average scores and print out the average for the whole album.
I have no idea how I did this in Access (been too long) and have no clue how to do this in OO.
Can somebody give me a hand?
Thanks.
Here is my table
Song Name
Music
Lyrics
Performance
Mix
Commercial Appeal
Album Name
Year
I have a query that adds (Music + Lyrics + Performance + Mix + Commercial Appeal) and then divides by 5 to get an average for each record. That works fine.
What I want is to create a query that will get an average for each album. So I know that the first thing I have to do is add up all the sums for each album and then compute the average.
So let's say I have 5 songs in an album named Album 1 and these are their average scores.
75
82
90
78
86
I want to be able to add up all those average scores and print out the average for the whole album.
I have no idea how I did this in Access (been too long) and have no clue how to do this in OO.
Can somebody give me a hand?
Thanks.