Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. HowardVenable

    Converting records to fields

    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.
  2. HowardVenable

    Converting records to fields

    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...
  3. HowardVenable

    Converting records to fields

    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).
  4. HowardVenable

    Converting records to fields

    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...
  5. HowardVenable

    Converting records to fields

    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...
  6. HowardVenable

    Converting records to fields

    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...

Part and Inventory Search

Back
Top