Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259

    Unanswered: Totals: Combining multiple records

    for a specific file number, there are multiple ppl names associated with it.

    e.g

    001 Jonny Godfather
    001 Mammy Moser
    001 Tammy Hilfiger

    Using the aggregate expressions, how would i in a query, display

    001 Jonny Godfather|Mammy Moser|Tammy Hilfiger

    Sum doesn't work..(only for numbers)..and i dont wanna write a function in VB
    Do you have to?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    look into cross tab reports
    oh yeah... documentation... I have heard of that.

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

  3. #3
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    259
    erm, been trying to meddle in that, no suceess;

    two fields is all i have

    FileNumber, and IndividualName
    with fileNumber having more than one invidual name per number.

    I just want to display two fields in the resultant query:
    FileNumber and InventorCombination

    001 in the first field and in the second field, "Inventor 1 | Inventor 2 | Inventor 3...."
    the crosstab requires three min, column header, row and value...

    could you show me how? thankx.

Posting Permissions

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