Concatenate 2 field with brackets

[jj1]

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.

[Bob Fitz]

Try:

CourseHours: [TrainingCourseList2].[2criteria] & " (" & [TrainingCourseList2].[Hours] & ")"

[jj1]

Thanks Bob. It worked.

[jj1]

I have one more question. How do I join two crosstab queries so that I have 2 column rows.
So for example, I want all people name in row heading of crosstab query and courses they need to learn in column heading and another column heading which is type of course.
Course A Course B Course C
Type A Type B Type C
Joe
John
Jessica

[CJ_London]

last question also posted in new thread