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
    826
    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
    3,022
    Post Thanks / Like
    Mentioned
    33 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
    I don't use vba in any form!

  3. #3
    Board Regular Skybluekid's Avatar
    Join Date
    Apr 2012
    Location
    Coventry England
    Posts
    826
    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
    3,022
    Post Thanks / Like
    Mentioned
    33 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
    I don't use vba in any form!

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
  •