Cross-Tab Query

• jmccary

  Mr or Mrs. 500

  Points: 541

  More actions

  May 21, 2004 at 9:39 am

  #161922

  I'm having a difficult time with this cross-tab query. Any help appreciated. Data is:

  ID  Word

  1   dog

  2   cat

  1   run

  3   horse

  1   good

  3   gallop

  3   run

  2   bad

  3   mane

  I would like a select statement to return the following (order of words for an ID is not important, however, the number of words for an ID is not fixed)

  ID  Word1  Word2   Word3   Word4

  1   dog       run       good

  2   cat       bad

  3   horse    gallop    run        mane

  TIA,

  John

• tymberwyld

  SSCertifiable

  Points: 7810

  More actions

  May 21, 2004 at 1:48 pm

  #507348

  Of course you're having dificulty!  You need another Column Called "WordType" which would discern whether it's a Verb, Noun, etc.

  Data:

  ID     Word     Type

  1      Dog       Noun

  2      Cat       Noun

  3      Bird       Noun

  4      Good     Attribute?

  5      Run       Verb

  6      Mane     Attribute?

   

  CrossTab:

  ID     Noun     Verb    Attributes

  1      Dog       Run     Mane