Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    162

    Unanswered: query field to include results from all other columns

    Instead of have a field to total all other columns. Like total in a crosstab query.

    I want to show results of all the columns with a column separating results.


    Like this


    ColA_ColB_ColC
    201__300_400
    100______500
    _____200_500

    I want one column to have all the info like so

    201,300,400
    100,500
    200,500


    TIA

    If i do a formula like so Col1 & "," & Col2 & "," & Col3 &","

    I will have extra commas in the field.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Try this, if the empty fields are Null:

    (Col1 + ",") & (Col2 + ",") & Col3
    Paul

  3. #3
    Join Date
    Sep 2006
    Posts
    162
    Works great, thanks.

Posting Permissions

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