Multiple reocrd line table into new table joing records on id

[Tonynhope]

Hi I have an access table with the following data(some columns omitted for
ease of reading):

MemberNo, Fname, Lname, Code
123456,John,Doe,A
123456,John,Doe,B
123456,John,Doe,E
345678,Ted,Test,C
345678,Ted,Test,E
345678,Ted,Test,F

ETC. I need to create a new table with the only one record line per ID with
the Code field either in one field for multiple fields within that record
line.

Please help. The deadline noose is tightening. Thank you

 

[Duane Hookom]

Since you have a deadline approaching, you should probably type in a few
records of how you would expect the new records to look. You refer to "one
record line per ID" but you don't show a field named ID in your example.

 

[tonynhope]

Sorry...I meant based on MemberNO
The resulting table should look like:
MemberNo,Fname,Lname,Code
123456,John,Doe,ABE
345678,Ted,Test,CEF

Thanks again

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.