could not query the data SELECT SID AS ID, FirstName, LastName, CONVERT(varchar, LectureDate, 101) AS Date, LectureTitle AS Speech, FortnightlyArticle, Series, VideoAudio AS Video, TimeLength AS [Time], VideoLink FROM SPEAKER INNER JOIN PATRONINPUT ON SPEAKER.SpeakerID = PATRONINPUT.PatronID WHERE (Date >= '1/1/1985' AND Date <= '12/31/1985') AND (Series LIKE '%JKL%' AND Series NOT LIKE '%JKLJ%') ORDER BY [Date]