I have a database that has been converted from Access 97 to Access 2000. My UNION ALL queries that try to union NULL place holder fields with real data are now giving me "Data type mismatch in criteria expression" errors (they worked fine in 97). The data is boolean in addition to dates.
I would like to know if there is a solution for this without having to change all the queries where I get this error (there are many). I have run a test case where I ended up changing the place holder NULL to 0 (I had to change 5 queries which cascade into the union all query).
Any help or advice is really appreciated!
I would like to know if there is a solution for this without having to change all the queries where I get this error (there are many). I have run a test case where I ended up changing the place holder NULL to 0 (I had to change 5 queries which cascade into the union all query).
Any help or advice is really appreciated!