Hi Barry, thanks for reply.
I guess it is as much about what you already use. I have given Access a little kick around today i.e. using the typical installed desktop software:
1). Basic Songs Information (qryArtistAlbumSong)
SELECT Left([AlbumArtist],255) AS AA, Left([Album],255) AS Albm, Val([DiscNumber]) AS DIsc, Val([TrackNumber]) AS Trck, Left([SongTitle],255) AS SngTtl, Val(Left([Year],4)) AS YR, Left([Genre],255) AS Gnr, Val([Rating]) AS Rate, Val([Bitrate]) AS BtRt, Val([BPM]) AS Beats, SongsTableImport.TrackType
FROM SongsTableImport
GROUP BY Left([AlbumArtist],255), Left([Album],255), Val([DiscNumber]), Val([TrackNumber]), Left([SongTitle],255), Val(Left([Year],4)), Left([Genre],255), Val([Rating]), Val([Bitrate]), Val([BPM]), SongsTableImport.TrackType
HAVING (((Val(Left([Year],4)))>1900) AND ((SongsTableImport.TrackType)=0))
ORDER BY Left([AlbumArtist],255), Left([Album],255), Val([DiscNumber]), Val([TrackNumber]);
2). Cross Tab to Highlight Albums with Multiple Genres and show number of tracks vs year (qryArtistAlbumSong_Crosstab)
TRANSFORM Count(qryArtistAlbumSong.SngTtl) AS CountOfSngTtl
SELECT qryArtistAlbumSong.AA, qryArtistAlbumSong.Albm, qryArtistAlbumSong.Gnr, Count(qryArtistAlbumSong.SngTtl) AS TotalSongs
FROM qryArtistAlbumSong
GROUP BY qryArtistAlbumSong.AA, qryArtistAlbumSong.Albm, qryArtistAlbumSong.Gnr
PIVOT qryArtistAlbumSong.YR;
3). Cut and paste into Excel - it is now quite quick to see - for example:
a). Genre anomalies vs the artist (or within an album?). See Angus & Julie Stone, Ben Harper, Billie Eilish
b). Albums where songs spread over several years - which might be OK or might be a problem!
https://octoberclub-my.sharepoint.com/: ... Q?e=bB1Edp