Results 1 to 11 of 11
  1. #1
    Join Date
    Mar 2008
    Posts
    3

    Unanswered: query help needed

    I have the following table of data:

    ID Value
    111 abc
    111 xyz
    111 nnn
    222 aaa
    222 bbb
    333 mmm
    444 123
    444 pqr


    I want a query that will output only one row per ID with the values listed horizontally in columns. Something like

    ID Value1 Value2 Value3 Value4
    111 abc xyz nnn
    222 aaa bbb
    333 mmm
    444 123 pqr

    I'm new to this, so thanks for the help if this is really simple.

    bajolyn

  2. #2
    Join Date
    Oct 2003
    Location
    Chicago, IL
    Posts
    34
    That's not a practical way to do this. It is the sort of thing I would do using a Macro.
    DigiOz Multimedia
    http://www.digioz.com

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yup... you're going to need to write a VBA function to do that.

    I've given the sample code on these forums already somewhere, you only have to find it. When you do, please post the link back here
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6

  5. #5
    Join Date
    Mar 2008
    Posts
    3
    Quote Originally Posted by StarTrekker
    Yup... you're going to need to write a VBA function to do that.

    I've given the sample code on these forums already somewhere, you only have to find it. When you do, please post the link back here
    Thanks for the help. Being a newbie to the forum, I looked for your posts but I'm having trouble finding the solution. Can you give me some guidance on what to search for? Appreciate it.

  6. #6
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Did post 4 escape notice?
    Paul

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Looks like it

    It's good to keep to the same forum isn't it?

    I'm not sure what to search for at this point... and tbh, the search functionality of this site is pretty lame.

    I'll check back later and try. If it's urgent, I suggest you follow the link in post 4 and see how you get on.
    Last edited by StarTrekker; 03-25-08 at 03:05.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Took me 20 minutes of searching. Dumb search. It doesn't restrict the results to just the Access forums

    Anyway, here it is:

    http://www.dbforums.com/showthread.php?t=1626996
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  9. #9
    Join Date
    Mar 2008
    Posts
    3

    Thanks

    StarTrekker and pbaldy,

    Thanks so much for your replys and patience - especially the 20 minute search for the old thread. I think I have what I need to give this a try. The information in the thread is very helpful and should provide me with what I need.

    Thanks for helping a newbie out.

    bajolyn

  10. #10
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by StarTrekker
    I'm not sure what to search for at this point... and tbh, the search functionality of this site is pretty lame.
    www.dbforums.com/search.php

    Bookmark it young one
    George
    Home | Blog

  11. #11
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Bookmarked!

    Thanks... where was THAT hiding!! ^^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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