1 Reply Latest reply on Jul 27, 2010 10:11 AM by philmodjunk

    Crosstab query

    crtopher

      Title

      Crosstab query

      Post

      In Access, I could create a "crosstab" query, where I could have a field arrange horizontally in a report, rather than vertically... so for example if my table was

      DATE NAME EVENT
      12/12/2009 Bob Birthday
      12/12/2009 Steve Anniversary
      14/12/2009 Dave Party

      etc...

      My report could look like this

      DATE Bob Steve Dave
      12/12/2009 Birthday Anniversary  
      14/12/2009     Party

      etc...

      How do i do this in FMpro11?

      Cheers

      Chris Richardson