Results 1 to 4 of 4
  1. #1
    Ayiramala is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Dec 2014
    Location
    Kerala, India
    Posts
    74

    How to add two fields in reports with ()

    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

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    In a textbox:

    =Field1 & "(" & Field2 & ")"
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Ayiramala is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Dec 2014
    Location
    Kerala, India
    Posts
    74
    Quote Originally Posted by pbaldy View Post
    In a textbox:

    =Field1 & "(" & Field2 & ")"
    That's it! Thank you so much.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Happy to help and welcome to the site by the way!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Empty Fields Calculated In Reports
    By steveabni in forum Reports
    Replies: 2
    Last Post: 12-17-2014, 05:56 PM
  2. Sorting on Sum Fields in Reports
    By fversluis in forum Reports
    Replies: 4
    Last Post: 08-17-2014, 12:23 PM
  3. Having issues with calculated fields in reports
    By Neologic29 in forum Reports
    Replies: 12
    Last Post: 08-17-2013, 05:18 PM
  4. Mutli-valued fields in reports
    By austinboy_1998 in forum Reports
    Replies: 1
    Last Post: 04-25-2011, 01:36 PM
  5. Reports- Auto Expanding Fields
    By mojo53777 in forum Forms
    Replies: 1
    Last Post: 01-10-2008, 05:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums