Name setup

[Josh Henry]

I have a table tenants, that has the following
fields: "OccLName" & "OccFName" and i like entering the
info this way. However, to join it with another table, i
need to have the names "OccLName, OccFName" as this other
table. Is there a way for me to enter the names as I was
doing (Last name in OccLName & first in OccFName) and they
be automatically entered into another field called Name,
which would be set up as follows: "OccLName, OccFName" ?
Would this be done at the table or form level?

 

[Jamie Richards]

Hi Josh,

Is it that you're asking how to join last name and first name together to
make one value called name? You said you have the fields (plural)
"OccLName" & "OccFName". You haven't joined those two have you? You have
an ampersand between them.

If they are separate and you want to join them for displaying in a form, you
can do it like so:

*************************************
Control Name:
txtName

Control Source:
=[OccLName] & ", " & [OccFName]
************************************

....where the form is bound to the data source (table).

Jamie

 

[Roger Carlson]

Store them separately! Then you can concatenate them in either 1) a query
2) a form or 3) a report.

In a query, you would create a column in the field list like this:
FullName: OccLName & ", " & OccFName
(Note: DON'T use Name as that is a reserved word)

In a form or report, create a textbox control and set the following in the
Control Source:
=OccLName & ", " & OccFName

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L