Bracket No WaY!!

[Guest]

In A report:

How Do make a bracket for a value in field?

eg Field: Fruit
Value inside : Apple, Pineapple, Papaya

Instead I want to see (Apple), (Pineapple) , (Papaya)

Any Solutions?

Thanks in advance

Kennykee

 

[Guest]

="(" & [Fruit] & ")"

 

[Guest]

= "(" & Replace([Fruits], ",", "),(") & ")"


Mauricio Silva