merge data in a query

[Kim Webb]

I have a list of 1000 records with only 1/3 unique. The table looks like this:

name recordID date
kim 000111 1/2/08
kim 000111 2/9/08
kim 000111 4/7/08

I want the table to look like this

name recordID date
count
kim 000111 1/2/08, 2/9/08, 4/7/08 3

Any idea how I would accomplish this in Access 2003?

 

[Jerry Whittle]

Try a crosstab query. I will look something like:

name recordID TotalCount 1/2/08 2/9/08 4/7/08 5/23/08
kim 000111 3 1 1 1
Tim 000123 3 1 1 1