Combining Information

  • Thread starter Thread starter Brian T
  • Start date Start date
B

Brian T

Hello,

I am looking to combine information from several parts of a record. I want
to take the initials for a persons name and add an ID number.
Example:
Last Name First Name MI ID #
--------------------------------------------
Doe John A 1234

Output: JAD1234

Thanks
 
Put something like below in a field for a query based on the query.

TheOutput: Left([First Name], 1) & Left([MI], 1) & Left([Last Name], 1) &
[ID #])
 
Back
Top