Subject Re: Query error From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Mon, 4 Sep 2023 10:27:00 +0530 Newsgroups dbase.getting-started Good Morning Tom, >> 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. > * Agree with Mervyn, Without the tables with just a few rows of data we cannot proceed further. Make a copy of the tables. Just leave 5 to 10 rows and delete the rest. Leave the Testdate,DemoNotes,DemoData etc field intact which are required for working for sql. Replace the rest with junk data. And post us the tables. my email is flight bags1 at gmail dot com. Regards Akshat