Hi all:
Here is the problem I have:
I need to change the name format from (Last Name, First Name) to (First Name Last Name), e.g Smith, John, but I want it to be John Smith. It can be easily done by excel, but my file is huge and Excel just can't handle it. Is there anyway I can do it in Access? Thanks

you could use something like

Right([yourfieldname],Len([yourfieldname])-InStr([yourfieldname],",")) & " " & Left([yourfieldname],InStr([yourfieldname],",")-1)

havent tested this but it should be close probably needs some tweaking

Thanks, it helped