How do I concatenate a list of first names?

[LeahRose]

How do I concatenate a list of first names with commas separating them and
the word "and" before the last one?

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.