[AccessD] Back in the saddle

[Rocky Smolin]

strTheWholeName = Trim(rs!FirstName) & " " &
iif(IsNull(rs!MiddleName),"",Trim(rs!MiddleName) & " " ) & rs!LastName

where rs is a recordset of the record with the three fields.


HTH

Rocky

On Fri, Apr 19, 2024 at 6:00 PM John Bartow <jbartow at winhaven.net> wrote:

> I'm using Access again, after many years away. I'm using it to migrate
> data from one messy cloud based LOB program's data to another messy cloud
> based LOB program. So I'm basically breaking it down to build it back up
> again.
>
> I need to compare [client name] (one field) "Joe D. Testguy" to [first
> name] "Joe" [middle name] "D." [last name] "Testguy" concatenated to be one
> field for this purpose. I used to use a function to do this and have the
> result with only 1 space between the 3 parts even if the middle name was
> null. Can one of you gurus refresh my memory as to how this is done?
>
> That's the fun part. The drag comes when someone put "Joe D Testguy and
> Jill D Testgal" as the [client name].
>
> TIA
> John B
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>