Bill/John, Thanks for the confirmation that a cross-tab is my best option.
Jan -----Original Message----- From: "John Engwer" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Sun, 14 Jun 2009 19:55:19 -0400 Subject: [RBASE-L] - RE: Row to Column 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
