|Subject:||Quickly concatenate non-duplicate text fields?|
|Posted by:||Aikistan (stan.mitchel…@gmail.com)|
|Date:||Mon, 7 Dec 2015|
Sorry, it's been so long since I've posted.
I don't have a lot of time to do this but it's a one-off cleaning up some b=
ad data. I have a table with long (>1000 characters) text fields Resp1, Re=
sp2, Resp3, and Resp4. I need to print these in a report but only one inst=
ance of them. There are duplicates where Resp1 =3D Resp3 or Resp2 =3D Resp=
4, but I only want one instance of any of the fields. For example, if:
I want to print "Apple." But, if:
I want to print "Apple <CR> Banana." ("Banana <CR> Apple" is acceptable.) A=
nd, how do I insert that Carriage Return? &"ALT num 20"?
I would prefer to do this with a query and expressions because I can debug =
those more easily but a VBA solution is also fine. Any help is greatly app=