Results 1 to 2 of 2
  1. #1
    Join Date
    May 2014
    Posts
    98

    Unanswered: Concatenate 2 field with brackets

    I want to concatenate 2 fields which is Course and Hours and I want hours to be in brackets.

    I am using this formula
    CourseHours: [TrainingCourseList2].[2criteria] & " " & [TrainingCourseList2].[Hours]
    I don't know how to add brackets to hours .

    I want it to look like this....

    Leadership (4) which would mean Leadership course is of 4 hours.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    The either so this in the presentation layer, the form or report
    Or modify your existing concatenation
    Mycolumn & " [" & myothercolum & "]"
    Or use a format
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •