Results 1 to 3 of 3
  1. #1
    ntambomvu is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Location
    Johannesburg south africa
    Posts
    91

    using a temp table to add date to main table

    Hello chaps,
    I am a newdie and am working my way through steve bishops tutorials on ms access
    In lesson 15 entitled "Make table and insert queries " he is showing how to add a record to the
    main table by first creating a temp table and then adding the new row in the temp table
    by appending it to the main table.
    To me--(imyi) it seems a long way around when one could just add a new row to the
    main table directly.
    could someone please tell me why this roundabout way is used?
    best regards and thank you


    fred

  2. #2
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,861
    I believe in the first part of the video he is demonstrating a make table query and in the second he is demonstrating an insert query.
    I don't think he means to use them together, he just happens to use the made table in the second part of the lesson.

    could someone please tell me why this roundabout way is used?
    There are instances where you might use them together however. One being importing data into a temp table to clean it up before
    appending it to your main tables.

  3. #3
    ntambomvu is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Location
    Johannesburg south africa
    Posts
    91
    thank you-- now it is clear!!
    regards

    fred

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 09-03-2014, 10:48 AM
  2. Replies: 7
    Last Post: 08-09-2013, 12:04 AM
  3. Updating main table from temp table AND form value
    By shabbaranks in forum Programming
    Replies: 8
    Last Post: 05-01-2013, 07:18 AM
  4. delete temp table
    By slimjen in forum Queries
    Replies: 1
    Last Post: 07-19-2012, 06:35 AM
  5. Query for temp linked table
    By compooper in forum Programming
    Replies: 8
    Last Post: 06-30-2011, 06:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums