newbie tearing his hair out HELP!!

itsglitzy

Registered User.
Local time
Today, 14:49
Joined
Nov 12, 2004
Messages
30
:confused: i have a column with usernames and numbers i.e rja01, 8765, sngg03, jkljkl344 and so on what i need is to remove all after and including the comma, please help thanking you inadvance
 
After what comma?

Or is rja01, 8765, sngg03, jkljkl344 an example of one record in one field? and you only want rja01?
 
oops

after the first comma i.e rja01, 1234
 
Left([MyField], InStr(1, [MyField], ",")-1)
 
you guys...........

thx so much 4 all your help that wa superb and keep up the good work ex :D cellent :D
 

Users who are viewing this thread

Back
Top Bottom