Current Record

[michael_parry2005]

Hi

I am creating a music database and could have more than one album per
artist, is there anyway to count the number of times an artists name
appears in on of the table coloum. eg. record 1 = abba then record 223
would also contain abba, so when the user looks at the database it tell
them on the first abba field that there is another.

thanks for your help

 

[michael_parry2005]

Thanks very much for that reply its been a great help

I not puting a better structure to the database

 

[michael_parry2005]

Thanks very much for that reply its been a great help

I now puting a better structure to the database