Field format 1

[Oz1127]

I have a field within a table like the following: Doe,John. Can someone help me with an expression that would switch it around? Like, John Doe. I'm getting everything but the result I want. Thanks in advance for the help.

 

[orna]

Try this:
Trim(right(Name, Len(Name) - InStr(Name, ","))) & " " & Trim(left(Name, InStr(Name, ",") - 1))

 

[orna]

Another way:
Dim a
a = Array()
a = Split(Name, ",")
The Result = trim(a(1)) & " " & Trim(a(0))

 

[PHV]

Yet another way:
Trim(Mid([Name field],1+InStr([Name field],","))) & " " & Left([Name field],InStr([Name field],",")-1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Oz1127]

Thanks Gyz, Is it also possible to use modules in Access and do the following?

Function ReverseString (MyString As String)
ReverseString = StrReverse(MyString)
End Function

http://support.microsoft.com/?kbid=210439

I didn't have to much luck with it it, just wanna know if there is another way of doing it.Trying to learn, ya know.