Search results

Re: Query error - The number of columns in the two selected tables or queries of ... Thanks for your help. I didn't write the code, so not sure why the * is there. I couldn't see the UNION part either which is why the error confised me. I tried removing the * and wraped Date in [ ] but still...

Hi, I'm new to Access. We have a database that was created years ago and has been working fine. Now suddendly we get the following error message on a query. "The number of columns in the two selected tables or queries of a union query do not match" This is the code SELECT [TimeSheets...