Reverse names in access?

[Cookies]

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

 

[rainman89]

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

 

[Cookies]

Thanks, it helped