Combining Fields

  • Thread starter Thread starter Anouska
  • Start date Start date
A

Anouska

Hi

I have 3 separate fields with title, first name and last
name. I want to be able to run an update query to a 4th
field which would combine all 3 fields eg Mr John Smith in
one field. Can you help me out?

Regards
Anouska
 
Anouska said:
Hi

I have 3 separate fields with title, first name and last
name. I want to be able to run an update query to a 4th
field which would combine all 3 fields eg Mr John Smith in
one field. Can you help me out?
Click to expand...

You should not run an update query to *store* this redundantly in another field.
That would be a major violation of proper relational database design. All you
need is the proper expression in a query, form, or report and this combined
output can be produced on-the-fly any time you need it.

CombinedName: [title] & " " & [first name] & " " & [last name]
 
Thanks for that I knew there had to be an easier way!

Cheers
Anouska
-----Original Message-----
Anouska said:
Hi

I have 3 separate fields with title, first name and last
name. I want to be able to run an update query to a 4th
field which would combine all 3 fields eg Mr John Smith in
one field. Can you help me out?
Click to expand...

You should not run an update query to *store* this redundantly in another field.
That would be a major violation of proper relational database design. All you
need is the proper expression in a query, form, or report and this combined
output can be produced on-the-fly any time you need it.

CombinedName: [title] & " " & [first name] & " " & [last name]


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.
Click to expand...
 
Back
Top