Display multiple fields in one field

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I use the following code to display multiple fields in one field
successfully.

Expr2: [TEAttendee1]+", " & [TEAttendee2]+", " & [TEAttendee3]

Results:

Susan Wu, John Ni,
Echo Peng, Chen Xiao-ping, Miao Chun-fang

The two-name result ends with a comma that is not I want. The three-name
result is exactly what I want. Can someone advise me how to avoid the comma
at the end of two-name result.

Thanks.

Ray
 
Try:

Expr2: [TEAttendee1] & (", " + [TEAttendee2]) & (", " + [TEAttendee3])
 
Douglas,

Your code is exactly what I want. Thanks so much!

Ray

Douglas J. Steele said:
Try:

Expr2: [TEAttendee1] & (", " + [TEAttendee2]) & (", " + [TEAttendee3])


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Ray said:
I use the following code to display multiple fields in one field
successfully.

Expr2: [TEAttendee1]+", " & [TEAttendee2]+", " & [TEAttendee3]

Results:

Susan Wu, John Ni,
Echo Peng, Chen Xiao-ping, Miao Chun-fang

The two-name result ends with a comma that is not I want. The three-name
result is exactly what I want. Can someone advise me how to avoid the comma
at the end of two-name result.

Thanks.

Ray
Click to expand...
Click to expand...
 
Back
Top