hmm
after suggestions
i used the following

SQL = "SELECT TOP 20 ArtistName, SongName, SongID, Location, SongTime, SongHits FROM Songs, Albums, Artists WHERE (Artists.ArtistID = Albums.ArtistID) AND (Albums.AlbumID = Songs.AlbumID) AND Songs.SongHits > 0 ORDER BY Songs.SongHits DESC"

but it doesnt get only first 20
it gets all that have Songs.SongHits > 0
so it returns all
grrr
any suggestion