Count?

[#1]

I've got a table with musician (ID, musician name,...) and table with their albums (ID, album name), so that musician1 have 4 albums, musician2 1 album,...

Now, I want to design a chart, that shows artists name and their number of albums. How can I do that? Thanks!

[#2]

Hi QursV52v,

Load

ID,MusianName from Table1;

Load

ID,AlbumName from Table2;

In chart just put a expression like count(Albumname) with ID or Musianname.

If you have any queries please let me know...

Regards,

Ravi....

[martin59]

Hello,

You have to put the Musician Name like dimension.

And your expression must be :

Count(Distinct ID_Album)

Regards,

Martin

[#4]

Where do I write 'Load...'?

'like count(Albumname) with ID' What do You mean with 'ID'?

[martin59]

You have to write your script to import data.

Folders --> Edit script.

You have got some assistant on bottom of window.

Martin

[#6]

I've edited the script as You wrote, but when I press reload it says to me: 'Cannot open file 'C:\Documents and Settings\...' Load ID, MusicianName from tblMusician' and the same for the Album...

[martin59]

What's your file ? xls ? mdb ? txt ?...

[#8]

mdb (Access DB)!

[#9]

Hi,

If it is a mdb then, You need to create a connection(First DSN) in script then select tables. if you are aware this activities then do, otherwise reply on the same.

Regards,

Ravi...