Filtering Data to Show a Specific Number of Records per Field?

[tatihulot]

Hello, may I please request a bit of assistance with creating a query?

What I want to do with my music collection database is create a tally of how many albums are connected to each artist.

I want to display the list so I see only the artists with 14 or more albums.

For example, in my database, the Beatles have 15 albums, Bruce Springsteen has 20, AC/DC has 18, and the Ramones and Bob Dylan both have 16.



Steely Dan and Pavlov’s Dog have less than 14, so I would not want them to appear in the list.

So, I’d want the list results to look something like this:
Artist Title Count
AC/DC 18
Beatles 15
Bob Dylan 16
Bruce Springsteen 20
Ramones 16


This is all I really want the query to do.

Is this possible, and if so, what’s the best way to do this? Will SQL be the best way to approach this?
Thank you.

music_current.zip

[Welshgasman]

Depends on your DB setup?
Do you have a table for Artists and a table for Abums ?

Or do you just have one table setup like an Excel spreadsheet?

[madpiet]

Create a totals query

I renamed the Music table to Artist.

SELECT Artist.Artist, Count(AlbumTitle.AlbumTitlePK) AS CountOfAlbumTitlePK
FROM Artist INNER JOIN AlbumTitle ON Artist.MusicPK = AlbumTitle.ArtistFK
GROUP BY Artist.Artist
HAVING (((Count(AlbumTitle.AlbumTitlePK))>15));

[tatihulot]

After doing some further research, I found out how to do this. Thank you for the replies.