Help with MP3 list imported from Excel

[alunkane]

I have impotred a table of my MP3 music collection from Excel in to Access.

The Fields it contains are: "Artist" - "Album" - "Track Name" - "Track No." - & "Duration"

I would like an option to be able to list only the Artist & Albums - However, when I try I end up with a list of duplicate values for the Album field (as these relate to track 1, track 2, track , etc...)

I'm sure there's a simple solution..

Can anyone please help....

Thanks,

Alun Kane

 

[JimmyK]

Without knowing too much more about what your database has, and how it's structured, try someting like this:

SELECT tblMusic.artist, tblMusic.album
FROM tblMusic
GROUP BY tblMusic.artist, tblMusic.album;

That query will group information by the artist and the album

 

[alunkane]

Thanks.... I didn't know about "Group By" - sounds like what I'm looking for, so I'll give it a go now...

many thanks