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

Try this --
Output: Left([Last Name], 1) & Left([First Name], 1) & [MI] & [ID #]
--
Build a little, test a little.


"Brian T" wrote:

> 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 #])
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Brian T" wrote:

> 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