You are going to need to write a parsing function in vba using the MID and LEN functions. I am assuming that every record will have the dash (-) as the separator. If that is so, then you could use that to identify the Len of each parsed string. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us
----- Original Message ---- From: Muhamed Faisal <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, February 27, 2008 11:03:30 PM Subject: [ms_access] Fw: Fwd: spliting data dear Can any body help me to split data i have a filed in a table in text data type,now i want to split it in to three field for eg:my sample tata like this:bf 01- 25*25-green now i want to split to three filed ie;first field is bf 01 second filed is 25*25 third filed is gree how it is possible regards faisal riyadh ____________ _________ _________ _________ _________ _________ _ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping [Non-text portions of this message have been removed] ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs [Non-text portions of this message have been removed]
