[AccessD] Back in the saddle

[John Bartow]

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