Multiple reocrd line table into new table joing records on id

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
Back
Top