Results 1 to 2 of 2
  1. #1
    carly_1991 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2017
    Posts
    1

    Adding new colums into existing table?

    Hi,


    So i just inherited this access project, and i've been informed requires very little maintenance but by the beginning of each year it requires to add 3 new columns (which correspond to the new year) in order o run a report, turns out the person that knew how to do it left without writting down any kind of pointer as how to do this and everyone says is very simple but no one knows the steps
    I have very little experience with access, have been watching some tutorials but i'm a little worried to move something i shouldn't

    Could anyone give me any steps as how to proceed?

    I have added the new columns to the design view, but i don't see the name of the new columns inthe relationship view, also i have no idea where should i edit the formula that this kind of coulmn have, it seemed very simple but i don't want to screw it up! I feel like i'm missing some steps

    Thank you for any info you could give me

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    you add columns in the design view, then go to every query, form and report that uses that table and add them there as well if required.

    It sounds like poor table design, you should never need to add columns for 'business as usual'

    if your table currently looks some like

    2015 val1..2015 val2..2015 val3..2016 val1..2016 val2..2016 val3
    A..............B..............C.............X..... ..........Y.............Z

    and you now want to add 2017 val1..2017 val2..2017 val3

    then that is a very poor design. It should be

    Year...val1..Val2..Val3
    2015..A......B......C
    2016..X......Y......Z

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

Similar Threads

  1. Adding Columns to an Existing Table
    By J Bhujanga in forum Queries
    Replies: 5
    Last Post: 11-08-2016, 07:38 PM
  2. I am stumped...adding field to existing table
    By tanyalee123 in forum Queries
    Replies: 6
    Last Post: 12-09-2013, 06:04 PM
  3. Replies: 5
    Last Post: 11-01-2013, 09:34 AM
  4. Replies: 1
    Last Post: 01-31-2012, 11:54 AM
  5. Adding records to existing table
    By Mclaren in forum Programming
    Replies: 5
    Last Post: 05-18-2011, 12:44 PM

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