Aggregating all name records in the Name field into a line???

[Joe M]

If I have a field with name records in a table. And I would like to create a
report that saves/aggregate all the names in each record as " Names1,
Names 2, Names 3, Names 4, Names 5, Names 6" in a single line. How do I do
it??

 

[GREGORY HICKMOTT]

i beleave it is name1 = name2 & name3 & name4 & name5
in sql it is [" = "name2 " & " name3 " & " name4 " & " name5]

 

[John Vinson]

If I have a field with name records in a table. And I would like to create a
report that saves/aggregate all the names in each record as " Names1,
Names 2, Names 3, Names 4, Names 5, Names 6" in a single line. How do I do
it??

You'll need some VBA code to do this. There's sample code at

http://www.mvps.org/access/modules/mdl0004.htm


John W. Vinson[MVP]
(no longer chatting for now)