merging columns - is this possible

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I'm using Access 2003 SP1. I have two fields, 'firstname' and 'lastname'
which I want to merge into a single 'name' field. Is it possible to do this?
 
On the report where you want the full name to appear, put a text box with
this Control Source:
=Trim([firstname] & " " & [lastname])
Make sure the Name of this text box is not the same as a field name (e.g. it
cannot be called firstname.)

In the table, you do want the 2 names in separate fields, to facilitate
searching. You do not want a 3rd column in the table with the combined
names, since it is so easy to combine them when needed.

More info about how and when to combine fields:
Calculated fields
at:
http://allenbrowne.com/casu-14.html
 
thanks for the reply.

The database, besides being used for various hard copy variations, also
forms the basis of a searchable CD-ROM - it was for the gui for this that I
was looking to merge the fields. However, it's since occurred to me that I
can do it via scripting in a rather similar fashion to what you suggest for
hard copy.

Thanks again for the quick and relevant reply.

Allen Browne said:
On the report where you want the full name to appear, put a text box with
this Control Source:
=Trim([firstname] & " " & [lastname])
Make sure the Name of this text box is not the same as a field name (e.g. it
cannot be called firstname.)

In the table, you do want the 2 names in separate fields, to facilitate
searching. You do not want a 3rd column in the table with the combined
names, since it is so easy to combine them when needed.

More info about how and when to combine fields:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

shanakie said:
Hi, I'm using Access 2003 SP1. I have two fields, 'firstname' and
'lastname'
which I want to merge into a single 'name' field. Is it possible to do
this?
Click to expand...
Click to expand...
 
Back
Top