Jan, Here's one way: CROSSTAB date BY member FROM tablename WHERE ....
Bill On Sun, Jun 14, 2009 at 6:37 PM, jan johansen <[email protected]>wrote: > 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 >
