I need to know an agregate function that concatenates fields, similar to sum() or count().
M Marwa Sep 27, 2005 #1 I need to know an agregate function that concatenates fields, similar to sum() or count().
K KARL DEWEY Sep 27, 2005 #2 Do you mean where Field1 = "Now is" and Field2 = "the time" to result in "Now is the time"? Then use -- My Results: [Field1] & [Field2]
Do you mean where Field1 = "Now is" and Field2 = "the time" to result in "Now is the time"? Then use -- My Results: [Field1] & [Field2]