query to list only one like name

[cawash]

I have a field that lists an artist name; title of a song; ablum cover.

i want to run a query when ran, it will give me only one listing of the artist.

the query i have right now lists all 115 occurrances of the same artist.

I just want each artist listed only once.

thanks

 

[Jon K]

You can use the word DISTINCT in your query. Open the query in Design View. Switch to SQL View and add the word, e.g.

SELECT DISTINCT ArtistName
FROM yourTable

 

[Pat Hartman]

If you want a list of only authors but not any of their material, then use the query that Jon suggested. If you want to list song titles for each author, the author's name will be repeated on each row. If you want a "pretty" list to print, use the query as the recordsource for a report and add a group by author. That will print the author's name once followed by all his material.

 

[cawash]

Thank you...that was exactly what I needed!