Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    54

    Unanswered: Query Output Format

    This may be a stupid questions, but since I do not know the answer, I have to ask. I am looking to select one field from a table, and turn the output into a comma separated list. Something like this:

    Select value from table

    Output: value1, value2, value3, valueN...

    If possible I would like to this as a query rather than a function, but I'll certainly take any help I can get.

    Thanks!

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    crosstab query.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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