Back to KCIX Online
   Debut Date        Peak Date        Peak Position   
KCIX Music Search     Loading Data... 
CDs: 2275
LPs: 253
12" Singles: 629
7" Singles: 901
MP3s: 8336
There was a problem opening the record set:
Data type mismatch in criteria expression.

SELECT Year.Year, Year.Chart, Format(Year.ChartDate, "mm/dd/yyyy") AS ChartDate, Format(Year.PeakDate, "mm/dd/yyyy") AS PeakDate, Year.ChartWeeks, Year.Top40Weeks, Year.Top10Weeks, Year.PeakWeeks, Year.FirstChartingSong, Year.OnlyChartingSong, yyChartType.*, Song.SongID, Song.Song, Song.LyricsURL, Artist.ArtistID, Artist.The, Artist.Artist, Version.Hit FROM (((((([Year] LEFT JOIN xxVersionYear ON Year.YearID = xxVersionYear.YearID) LEFT JOIN Version ON xxVersionYear.VersionID = Version.VersionID) LEFT JOIN xxSongVersion ON Version.VersionID = xxSongVersion.VersionID) LEFT JOIN Song ON xxSongVersion.SongID = Song.SongID) LEFT JOIN xxSongArtist ON Song.SongID = xxSongArtist.SongID) LEFT JOIN Artist ON xxSongArtist.ArtistID = Artist.ArtistID) LEFT JOIN yyChartType ON Year.ChartTypeID = yyChartType.ChartTypeID WHERE Format([Year].[PeakDate],"mm/dd/yyyy") = '' ORDER BY yyChartType.ChartTypeID, Year.Year, Val(Year.Chart), RIGHT(Year.PeakDate, 4), LEFT(Format(Year.PeakDate, "mm/dd/yyyy"), 2), RIGHT(LEFT(Format(Year.PeakDate, "mm/dd/yyyy"), 5), 2), Song;