By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,779 Members | 1,309 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,779 IT Pros & Developers. It's quick & easy.

Combining Field Values

P: n/a
I need to combine fields values: FirstName and Last Name to Full Name in
the same table. I like to put the value on the full name after completing
entry for the full name. Thanks for the help.

WW
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Thu, 22 Apr 2004 18:34:16 GMT, epascual wrote:
I need to combine fields values: FirstName and Last Name to Full Name in
the same table. I like to put the value on the full name after completing
entry for the full name. Thanks for the help.

WW


Actually, you don't need to combine them and store it in the same
table.

Right now you have your data properly stored in 2 fields, [FirstName]
and [LastName].
That's all you need.

Whenever you want to show the 2 names together, in a query, form, or
report, simply combine them.
In a form or in a report, as an unbound control's control source,
write:
=[FirstName] & " " & [LastName]

In a query,
FullName:[FirstName] & " " & [LastName]

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 12 '05 #2

P: n/a
thanks fred, however, what i wrote is just an example, i need to do it on
field extracted from other fields (some in parts and other whole field
value), tried to do it using default value, but did not work. thanks for
the tip.

"fredg" <fg******@example.invalid> wrote in message
news:f5****************************@40tude.net...
On Thu, 22 Apr 2004 18:34:16 GMT, epascual wrote:
I need to combine fields values: FirstName and Last Name to Full Name in the same table. I like to put the value on the full name after completing entry for the full name. Thanks for the help.

WW


Actually, you don't need to combine them and store it in the same
table.

Right now you have your data properly stored in 2 fields, [FirstName]
and [LastName].
That's all you need.

Whenever you want to show the 2 names together, in a query, form, or
report, simply combine them.
In a form or in a report, as an unbound control's control source,
write:
=[FirstName] & " " & [LastName]

In a query,
FullName:[FirstName] & " " & [LastName]

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.