I itsglitzy Registered User. Local time Today, 14:49 Joined Nov 12, 2004 Messages 30 Nov 12, 2004 #1 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
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
Mile-O Back once again... Local time Today, 14:49 Joined Dec 10, 2002 Messages 11,316 Nov 12, 2004 #2 After what comma? Or is rja01, 8765, sngg03, jkljkl344 an example of one record in one field? and you only want rja01?
After what comma? Or is rja01, 8765, sngg03, jkljkl344 an example of one record in one field? and you only want rja01?
I itsglitzy Registered User. Local time Today, 14:49 Joined Nov 12, 2004 Messages 30 Nov 12, 2004 #3 oops after the first comma i.e rja01, 1234
I itsglitzy Registered User. Local time Today, 14:49 Joined Nov 12, 2004 Messages 30 Nov 12, 2004 #4 hello any help on this pls desp
Mile-O Back once again... Local time Today, 14:49 Joined Dec 10, 2002 Messages 11,316 Nov 12, 2004 #5 Left([MyField], InStr(1, [MyField], ",")-1)
I itsglitzy Registered User. Local time Today, 14:49 Joined Nov 12, 2004 Messages 30 Nov 12, 2004 #6 you guys........... thx so much 4 all your help that wa superb and keep up the good work ex cellent