AnsweredAssumed Answered

Crosstab query

Question asked by crtopher on Jul 26, 2010
Latest reply on Jul 27, 2010 by philmodjunk

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

Outcomes