| re: Combining Field Values
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" <fgutkind@example.invalid> wrote in message
news:f5ra624eetnm$.vx169md8i2li.dlg@40tude.net...[color=blue]
> On Thu, 22 Apr 2004 18:34:16 GMT, epascual wrote:
>[color=green]
> > I need to combine fields values: FirstName and Last Name to Full Name[/color][/color]
in[color=blue][color=green]
> > the same table. I like to put the value on the full name after[/color][/color]
completing[color=blue][color=green]
> > entry for the full name. Thanks for the help.
> >
> > WW[/color]
>
> 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.[/color]
| 
