Adding another Column
Results 1 to 4 of 4

Thread: Adding another Column
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular Skybluekid's Avatar
    Join Date
    Apr 2012
    Location
    Coventry England
    Posts
    823
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Adding another Column

    Hi All,


    I have an existing Query which gets its data from an Excel Table. I would to include a column from the excel Table, which is not in the existing query. Can this be done?


    Thanks in Advance
    Always awake not always on the Ball

    - Want to post a small screen shot? Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,575
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Adding another Column

    it depends on the structure but in general: it can be done
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #3
    Board Regular Skybluekid's Avatar
    Join Date
    Apr 2012
    Location
    Coventry England
    Posts
    823
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding another Column

    I have 3 queries all coming from 3 tables, which are all in separate worksheets. They combine into one query which in turn loads into a table. I would like to add 1 column from each of the separate worksheet which was not loadef in the original query.
    Always awake not always on the Ball

    - Want to post a small screen shot? Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,575
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Adding another Column

    post an example and expected result
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •