Combining Information

[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

 

[KARL DEWEY]

Try this --
Output: Left([Last Name], 1) & Left([First Name], 1) & [MI] & [ID #]

 

[Jerry Whittle]

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 #])