Report error - Operand without an operator

[Light1]

Hi - I am completely new to access - this is my first project and I have a question that is probably extremely easy for most.

I am trying to take two fields of information and combine them in to one field on a report. I have the following code in the Control Source:
=[tblAdmittingNur se.First Name]&” “&[tblAdmittingNur se.Last Name]
I receive the error "You may have entered an operand without an operator"
What am I missing? From everything I have looked at, it seems like it should work.

Thanks for any help you can give me.

[ADezii]

Hi - I am completely new to access - this is my first project and I have a question that is probably extremely easy for most.

I am trying to take two fields of information and combine them in to one field on a report. I have the following code in the Control Source:
=[tblAdmittingNur se.First Name]&” “&[tblAdmittingNur se.Last Name]
I receive the error "You may have entered an operand without an operator"
What am I missing? From everything I have looked at, it seems like it should work.

Thanks for any help you can give me.

'It seems as though you are directly referring to Table Values, you must explicitly reference the the Control names on the Report itself as in:
[CODE=vb]=[txtFirst Name] & ” “ & [txtLast Name][/CODE]

[Light1]

'It seems as though you are directly referring to Table Values, you must explicitly reference the the Control names on the Report itself as in:
[CODE=vb]=[txtFirst Name] & ” “ & [txtLast Name][/CODE]

It worked. Thank you - I really appreciate your quick response.

[NeoPa]

Be careful.
It seems you are using a word processor (like MS Word) to create your code. SQL will not recognise the double-quotes used (” & “). It only recognises (' & "), and the (") are only recognised in Jet SQL (See Quotes (') and Double-Quotes (") - Where and When to use them).

[ADezii]

It worked. Thank you - I really appreciate your quick response.

Glad to be able to help you out.