HOME    SONG   ARTIST   COLLECTION    CHART     YEAR        Misc   A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z       Misc   A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z       Misc   A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z       Debut Date        Peak Date        Peak Position    KCIX Music Search     Loading Data...    Song Artist Collection  Exact:

CDs:  2275 LPs:  253 12" Singles:  629 7" Singles:  901 MP3s:  8336 TOTAL SONGS:  32176

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;