Concatenation

[Nenya]

I have a report with 2 fields (coming from a query).
One field is a name, and the other is an id number.
I want something like this :

name (idnumber)

Is there a simple way (meaning, no coding or no invisible fields) to do this? I looked at the string functions, but i don't know which one i should use!

Thx if you can help

 

[Bryan F]

create an unbound text box on the report. in design view click into the text box and type this (replacing field names with your own of course).

=[Name] & " (" & [idnumber] & ")"

make sure you have that = sign in there.

 

[Nenya]

I tried this... but it doesn't work. I get an error instead!

 

[Bryan F]

=Me.Name & " (" & Me.idnumber & ")"

try this... also make sure that Name and idnumber are actual fieldnames in the recordset of your report

 

[Nenya]

It looks like shuting down access and reopen my database fixed the problem.

Thx anyway!