How to combine two field in one field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan48 - 29 Jul 2005 04:43 GMT

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.

Reply to this Message

Allen Browne - 29 Jul 2005 04:46 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> In the acees, I got two field call: Name, Othername
> For example:
[quoted text clipped - 14 lines]
> do
> something in query first? Thank you very much.

Reply to this Message

Alan48 - 29 Jul 2005 05:19 GMT

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

> Try:
> =[Name] & " " & [Othername]
[quoted text clipped - 6 lines]
> or any other field name: Access gets confused if a control has the same name
> as a field, but is bound to something else.

Reply to this Message

Alan48 - 29 Jul 2005 05:27 GMT

Sorry,Allen Browne. It works now. thanks for your help.

> Try:
> =[Name] & " " & [Othername]
[quoted text clipped - 25 lines]
> > do
> > something in query first? Thank you very much.

Reply to this Message

David C. Holley - 29 Jul 2005 05:59 GMT

.ControlSource = [FirstFieldName] & " " & [SecondFieldName]
or in the recordSource
exprFieldName: [FirstFieldName] & " " & [SecondFieldName]

> In the acees, I got two field call: Name, Othername
> For example:
[quoted text clipped - 13 lines]
> 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.

Reply to this Message