Merging two field together

[Guest]

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,

 

[Rick B]

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.