merge data from multiple records

[Guest]

I have an access table which has duplicate records with the exception of one
text field which has different data in each record. I would like to combine
the text from the multiple records into one record so I can delete the
duplicate records.

 

[Guest]

How many duplicates records? Two or more? Any none duplicate records?

Does the table have a primary key or a unique index?

What you probably need is one table with all the duplicate data pared down
then another table with the field having the different data plus a foriegn
key field. For this to work you'll need a primary key in the first table.

 

[Guest]

sample of table structure

work order# task# notes
1234 1 looked at work
1234 1 ordered material
1234 1 finished job

I want to create a new table with one record which combines the notes field
from the 3 records into one field i.e.

work order# task# notes
1234 1 looked at work, ordered material, finished job