ex
columns

Name Day1 Day2 Day3 Day4 Day5 Day6
Jackie s s
Jackie v v
Jackie p p


I would like to be combined into

Jackie s s p v v p

all in one row.

I suspect this thread Here may provide some inspiration, or even perspiration! (http://www.access-programmers.co.uk/forums/showthread.php?t=71302)