Using Access 2002 on Win XP:
I have a single name field capturing full names in F-M-L order (John Doe, James E. Dough, etc.) Some names have middle initials, some do not.
In a report, which is based on a query, I would like to accomplish two things: 1), have the names appear as Dough, Jame...