how to delete characters at end of a field??

[jmorlock]

I have just imported a few databases into Access and there are extra characters at the end of each phone number like
"7153695054 |1|0| ""(-- ". I want to go thru each record and remove the " |1|0| ""(-- " from each phone number. Does anyone have some suggestions of how to do this besides deleting it record by record. Maybe a short macro or something would do the trick. Any help would be appreciated.. Thanks in advance,

Jeremy

Sincerely,

Jeremy J. Morlock
IT Specialist

PatentWizard, LLC
E-mail: jeremy@PatentWizard.com
Web Site:

http://www.PatentWizard.com

 

[SgtJarrow]

if they are all ten digits as the beginning, use an update query, select the field in question and put:

Left([fieldname], 10)

in the updateto line....run it, your done.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
Network Admin/Access Programmer

 

[jmorlock]

Robert,

thank you very much. That worked perfectly and was alot quicker than goin thru and deleting them manually.

Sincerley,

Jeremy

Sincerely,

Jeremy J. Morlock
IT Specialist

PatentWizard, LLC
E-mail: jeremy@PatentWizard.com
Web Site:

http://www.PatentWizard.com