Search results

So, I'm analyzing data and I'm building a query where I can see all of table B and matching table A. It's like an "Unmatched Query" without the "WHERE A.MAINCODE = Null;". Here's a simplified version of my query: SELECT B.*, A.* FROM A RIGHT JOIN B ON A.MAINCODE = B.MAINCODE WHERE...

Hello everyone. I'm Jean-Marc from Ottawa, Canada. I work in the government, mostly with HR data. I've been using, building and programing MS-Access since version 97. This is 50-75% of my work depending on the feature requested. Some features I've developed use interoperability with Excel, Word...