How to add two fields in reports with ()

[Ayiramala]

Hello,
I am new to the site and this is my very first post.
I am working on this database, and needs help with it. There are two fields on this form, and in the report I want these two values to show in one filed, with the second one after the first one insde brackets. Like this: John(Chairman).John and Chairman belong to two separate fields on the form. How can I do this? Any help is greatly appreciated.



Regards,
Winston Ayiramala

[pbaldy]

In a textbox:

=Field1 & "(" & Field2 & ")"

[Ayiramala]

In a textbox:

=Field1 & "(" & Field2 & ")"

That's it! Thank you so much.

[pbaldy]

Happy to help and welcome to the site by the way!