Quickly concatenate non-duplicate text fields?

Giganews Newsgroups
Subject: Quickly concatenate non-duplicate text fields?
Posted by:  Aikistan (stan.mitchel…@gmail.com)
Date: Mon, 7 Dec 2015

Hello everyone,

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:

Resp1=3D"Apple"
Resp2=3D"Apple"
Resp3=3D"Apple"
Resp4=3D"Apple"

I want to print "Apple." But, if:

Resp1=3D"Apple"
Resp2=3D"Apple"
Resp3=3D"Banana"
Resp4=3D"Apple"

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=
reciated.

Stan

Replies