Search results

You are right thank you

I have the following code, the purpose of the code is that to take all rows from each table to append them into one table. However, I am testing this code with 2 tables (Table2 and Table3) each table has 2 records, when I run the code, it keeps adding records to table 1 that exceeds one million...

Thank you so much for your reply. I am getting a message " JOIN expression not supported". I guess that this would work for SQL Server but not Access?

I have a query "qryConversion_Cases" which is pulling data from a table called "tblInitialExtraction". This query has the following fields Client_Name, Case_ID, EntityID I am Trying to add another calculated field "RC_Case_ID" with subquery to check if the Case_ID exist in another query...