If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merging two field together
Hi,
I am trying to create a field called UserID. It will be based on two other fields: FirstName and LastName. What I want to do is to get the first letter of the first name and then combine it with the last name. So if I have John in my FirstName field and Smith in my last name field I am looking for a way to create the UserID field with the value JSmith. Can anyone help? Thanks, -- Chuck W |
#2
|
|||
|
|||
Merging two field together
In your reports and forms, just create an unbound field with the following:
=Left([FirstName],1) & [LastName] In your queries, create a new column and put the folowing: UserID: Left([FirstName],1) & [LastName] You would not store this in your table, as it is redundant. What if you have two "J Smith"s? How will you create the UserID? Since you would have two different ones, you might at this point store it in your table and just use the instructions above to create the default one. -- Rick B "ChuckW" wrote in message ... Hi, I am trying to create a field called UserID. It will be based on two other fields: FirstName and LastName. What I want to do is to get the first letter of the first name and then combine it with the last name. So if I have John in my FirstName field and Smith in my last name field I am looking for a way to create the UserID field with the value JSmith. Can anyone help? Thanks, -- Chuck W |
Thread Tools | |
Display Modes | |
|
|