Search results for query: *

Hi, Tried Updating again but, this time I did it after the Appending and it worked. Problem solved. The key/trick- Append first then use Update there after. Thanks for all your help Remou & PHV.

Thanks for catching that, There identical and the second line was to read as: INSERT INTO Chpt1_4 ( BASE, MAJCOM, [YEAR], CH1_4_2, CH1_4_2_Cost, CH1_4_2_Date, CH1_Remarks) SELECT [7 Fire Department].Base, [7 Fire Department].Majcom, [7 Fire Department].Year, [4 Deficiency].Per AS CH1_4_2, [4...

Please disregard this thread and refer to the thread 701-1101147 in the Programmers Area. Sorry one to many posts at a time (My first time posting treads).

Hello Thank you for the tip Remou. Here is the SQL for the first couple of queries and some notes. Keep in mind that on the DB1 table the three feilds BASE, MAJCOM & YEAR are a key. I have set them and any text to Allow Zero Length INSERT INTO Chpt1_4 ( BASE, MAJCOM, [YEAR], CH1_4_1...

Objective: Transferring data from one table to the other table. Problem: DB1 table has many fields (over 50), Runs linearly covering many chapters. BASE / MAJCOM / YEAR / CH1_4_1 / CH1_4_1_Cost / CH1_4_1_Date Text ! Text ! Date ! Number ! Currency ! Date...

Objective: Transferring data from one table to the other table. Problem: DB1 table has many fields (over 50), Runs linearly covering many chapters. BASE / MAJCOM / YEAR / CH1_4_1 / CH1_4_1_Cost / CH1_4_1_Date Text ! Text ! Date ! Number ! Currency ! Date...