agregate function that concatenates fields

M

Marwa

I need to know an agregate function that concatenates fields, similar to
sum() or count().
 
K

KARL DEWEY

Do you mean where Field1 = "Now is" and Field2 = "the time" to result in
"Now is the time"?
Then use --
My Results: [Field1] & [Field2]
 
Top