Unique songs per artist

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Unique songs per artist

relations

by Rudi Maes » Sun Feb 15, 2004 2:15 am

Hello,

I know it can be done in Access, but as I'm not acquainted with relations in a database, in the query I can't get the relation between the songs and artists table working. I think I should take a course in Access first. :(

Thanks for the tip anyway,
Rudi

by roylayer » Sat Feb 14, 2004 2:45 pm

In the meantime, stuff like that is pretty easy to do directly in the Access database if you know Access (or other database query languages).

Statistics

by Lowlander » Sat Feb 14, 2004 12:17 pm

Some statistics about the songs in the DB has been requested before. Not as advanced as you are requesting, but we'll have to see what the programmers do in this area.

Unique songs per artist

by Rudi Maes » Sat Feb 14, 2004 11:00 am

Hello,
I like to know what and how many songs I have per artist, without the duplicates. Is this possible now or could this be build in a future version?
I know it is possible to remove the duplicate titels, but that's not my intention.
In MS Access there's a function called 'group by" with wich it can be done, but is this possible in MM?
Thank You for a great program,
Rudi

Top