Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009

    Unanswered: Multipule Records to One Record

    Good morning, I need a many records to one conversion, like so

    ID    f
    a     x
    a     l
    a     k
    b     g
    c     g
    c     x
    ID  f1  f2  f3
    a    x  l   k
    b    g
    c    g  x
    Im going to guess that multiple query's are needed, but thats as far as I can get. thanks for any help

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    That's a "crosstab" in Access-speak. There should be a wizard for it IIRC.
    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