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

    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


  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Nevada, USA
    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:

    Paul (wino moderator)
    MS Access MVP

  3. #3
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    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