Want To insert an "and" statement

[Nomi123]

This is really a simple issue but I am having a totally "elderly moment" and cannot remember how to do it. I simply want to take the Interviewer 1 column and insert a couple of spaces and then add the Interviewer Email column so that they show up on the same line in my report.

From my terrible memory I have tried the following statement:

-([INTERVIEWER 1] & " " & [INTERVIEWER EMAIL])

It doesn't work. Were am I going wrong?

 

[pbaldy]

Try

=[INTERVIEWER 1] & " " & [INTERVIEWER EMAIL]

Make sure you don't have a textbox with the same name as either field, as that can confuse Access.