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
