I have a text field that has a full name (ie. Smith, John). I need to somehow split this into a first and last name...or at least reverse the order for a mailing list.

Can anyone help me?

http://www.access-programmers.co.uk/forums/showthread.php?t=130070