Combining Field Values

[epascual]

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

[fredg]

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.

[epascual]

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.