Query Concatenate Issue

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

I'm using Access XP. I have the following data in a table:

Field1 Field2 Field3
1 111 Main St.
2 111 Main St.
3 111 Main St.
4 222 1st Ave.
5 222 1st Ave.

What I would like to do is have a query based on this
table return the following 2 record result:

Field1 Field2 Field3
1,2,3 111 Main St.
4,5 222 1st Ave.

Any help would be greatly appreciated.

Thx.
 
Back
Top