Results 1 to 3 of 3
  1. #1
    M.Enders is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jun 2017
    Posts
    9

    Make Table


    Good Morning All,

    I am working with queries to make tables, and I cannot seem to find a way to run a query then automatically add a few columns into the table for addition information that will need to be added via a form. Does anyone happen to know of a solution?


    Thank you so much


    Marty

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    First of all, why are you making a lot of tables? This is typically a sign of a design mistake. If necessary, you could use DDL SQL to add columns:

    ALTER TABLE...
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    rather than make table, create your table as you want it including the additional fields then use an append query to populate the fields as used in your make table query

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

Similar Threads

  1. Replies: 4
    Last Post: 03-08-2018, 03:27 PM
  2. Replies: 2
    Last Post: 08-12-2016, 07:00 AM
  3. Replies: 2
    Last Post: 02-17-2015, 01:01 PM
  4. Replies: 1
    Last Post: 04-26-2013, 05:30 PM
  5. Replies: 2
    Last Post: 10-27-2009, 07:09 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