By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,304 Members | 1,739 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,304 IT Pros & Developers. It's quick & easy.

Copying text portion of a field to a seperate field

P: n/a
Hello and thanks,

I have about 200,000 records in an Access 2002 table with a "Disc
Code" field that contains data like the following:

Disc Code
AC2004
VAX1586
TDQV12

I would like to copy the text portion of this field to a separate
field leaving the original intact for the following result:

Disc Code Manufacturer Code
AC2004 AC
VAX1586 VAX
TDQV12 TDQV

Can this be done with an Update Query and some fancy use of wildcards
or is a macro and some functions (neither of which I am not very
familiar with) necessary?

Steve
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.