There are a couple of ways of looking at it. One if the the NAME field is just a first name and a last name. Then you could use instr to find the space, then use the left and right functions to reorder the name. If the name is more complicated (two first name, first name - middle) then you should be able to use instr again, but in a loop where you basically trim off everything but the last name. It would take some programming skill for the second one.
Of course if someone else has something simpler, let us know.
IP Logged
