How to combine two field in one field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the acees, I got two field call: Name, Othername
For example:
Name Othername
Michael Jordan
Reggie Miller

I want the display in report can show as below:
Micheal Jordan
Reggie Miller

This two field combine to one text field

I have tried change it to
[Name] && [Othername]

But i doesn't work. Then how can i do to solve this problem? Do i need to do
something in query first? Thank you very much.
 
Try:
=[Name] & " " & [Othername]

Actually, Name is not a good name for a field. Most objects in Access have a
Name property, so you could end up with Access showing the name of the
report instead of the contents of the Name field.

You also need to make sure that this text box is not named Name or OtherName
or any other field name: Access gets confused if a control has the same name
as a field, but is bound to something else.
 
Is it a create a new text field and type in this
=[Name] & " " & [Othername]
in control source?

It prompt out error. I have changed the field name to [FULLNAME], [CFULLNAME]
already. it still prompt out error. Did i do the wrong step? thanks
 
Sorry,Allen Browne. It works now. thanks for your help.

Allen Browne said:
Try:
=[Name] & " " & [Othername]

Actually, Name is not a good name for a field. Most objects in Access have a
Name property, so you could end up with Access showing the name of the
report instead of the contents of the Name field.

You also need to make sure that this text box is not named Name or OtherName
or any other field name: Access gets confused if a control has the same name
as a field, but is bound to something else.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Alan48 said:
In the acees, I got two field call: Name, Othername
For example:
Name Othername
Michael Jordan
Reggie Miller

I want the display in report can show as below:
Micheal Jordan
Reggie Miller

This two field combine to one text field

I have tried change it to
[Name] && [Othername]

But i doesn't work. Then how can i do to solve this problem? Do i need to
do
something in query first? Thank you very much.
Click to expand...
Click to expand...
 
..ControlSource = [FirstFieldName] & " " & [SecondFieldName]
or in the recordSource
exprFieldName: [FirstFieldName] & " " & [SecondFieldName]
 
Back
Top