Subject Re: Query error From Mervyn Bick <invalid@invalid.invalid> Date Sun, 3 Sep 2023 15:32:19 +0200 Newsgroups dbase.getting-started On 2023/09/03 14:14, Tom wrote: > * Above worked to perfection ... > * >> browse >> >> If this is working then you have a better base. >> Next step would be where with fixed values >> >> Select CAST(TestDate as Char(10)) d.TestDate,d.Provider, d.Client, >> d.Category, d.Allergen, d.TestLevel, d.StdTestRange, n.Demodata_Notes >>            FROM DemoData d Left Join DemoNotes n On n.Fk_DemoData = >> d.Pk_DemoData WHERE d.TestDate LIKE '03.09.2023' >> > * > Changed fixed value to '12/17/2013' a valid entry in the table. > * > Result: > Error message: Database Engine Error: Type mismatch in expression. > * Unless there is confidential information in the tables would you mind giving me a copy of your two tables? My email address is bickmeo at gmail dot com Mervyn