Crosstab looks like the way to go. If you need to manipulate the data after you have it in the crosstab format you could create a temp table; create a crosstab and output to a file; then load the crosstab data into the temp table. You will end up with a table in a crosstab format. I do a lot of those processes in my applications where I am dealing with shoe size and widths.
John From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Sunday, June 14, 2009 6:38 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Row to Column Group, I have a membership attendence table that records in a row fashion i.e. Member Date 1 01/01/2009 2 01/01/2009 3 01/01/2009 1 01/08/2009 2 01/08/2009 1 01/15/2009 3 01/15/2009 I know need to represent this in columns i.e. Member 01/01/2009 01/08/2009 01/15/2009 1 X X X 2 X X 3 X X I am just drawing a blank on how to accomplish this. I think I could use a crosstab but I like to figure out in a view. Jan
