Copy the same column into 1 record

[gooseriver]

Access 2000
Table1
Columns:
-ContactName (text)
-Notes (text)

Example:
John Smith Test1
John Smith Test2
John Smith Test3
Dave Brown Test1

Using a query how can I group by ContactName and conactenate the Notes into 1 column
Example:

(one record) John Smith Test1 (carriage return)
Test2 (carriage return)
Test1 (carriage return)

(one record) Dave Brown Test1

 

[PHV]

Have a look here:
faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[gooseriver]

How do I connect this module with the sql query? Sorry I am confused... I have created the two tables and have the code in a module... How do I execute this?

 

[gooseriver]

Resolved - amazing!