Search the Community
Showing results for tags 'expression'.
When I try to run this update query in ms access 2007 I get an error box message that says "Data type mismatch in criteria expression". I know the problem is at the end around replace(property.[park city]," ","")=replace(locations2011.city," ",""). But I checked the data types for all the related columns, which is text, and they all match for both tables. If I put quotes around property.[park city] or remove the replace function from it, the query will run but obviously not how I want it to. I've tested this code with a smaller table and it works so what's the problem? UPDATE property, locat
Hi, So I'm hoping to get some pointers on identifying namespaces and data contained within them. I have the task of transforming some (to my mind at least) unusual xml and I've not been able to successfully navigate it. Here's an example of the xml: <Report><ReportHost name="SampleHostName"><HostProperties><tag name="End_Time">Fri Jul 30 16:14:56 2010</tag><tag name="mac-address">00:00:00:00:00:01</tag><tag name="os_name">Microsoft Windows</tag><tag name="hostname">TestHostname</tag><tag name="Start_Time">Fri Jul 30 16