Name setup

  • Thread starter Thread starter Josh Henry
  • Start date Start date
J

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?
 
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
 
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
 
Back
Top