Results 1 to 3 of 3

Make Table

  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 online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    19,096
    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
    www.BaldyWeb.com

  3. #3
    Ajax is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    6,352
    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, 02:27 PM
  2. Replies: 2
    Last Post: 08-12-2016, 06:00 AM
  3. Replies: 2
    Last Post: 02-17-2015, 12:01 PM
  4. Replies: 1
    Last Post: 04-26-2013, 04:30 PM
  5. Replies: 2
    Last Post: 10-27-2009, 06: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
  •  
Tech Forums: Microsoft Office Forums