Query Concatenate Issue

[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.

 

[Duane Hookom]

Check out the Generic Concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Craig]

Duane,

Thx for the assistance.

-----Original Message-----
Check out the Generic Concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hook om,Duane

--
Duane Hookom
MS Access MVP





.