merge data in a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kim Webb - 22 May 2008 20:19 GMT

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?

Signature

Thanks for the help!

Reply to this Message

Jerry Whittle - 23 May 2008 15:48 GMT

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

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I have a list of 1000 records with only 1/3 unique. The table looks like this:
>
[quoted text clipped - 10 lines]
>
> Any idea how I would accomplish this in Access 2003?

Reply to this Message