Access Database- Split Field into 2 fields
Posted on 2007-11-27
I have an access database with a field called acct. The field is varying lengths of numbers.
Based on the field "Application" I need to move the last 3 or 5 numbers at the end to another field that I can create in the DB. For example, If Application is IRA and the account number is 111111111222, I need to move the 222 to a separate field and remove it from the account number field. But the 111111111 could be from 4 to 9 characters long and still have a 3 digit "sub number". I just need the 222 sub number removed. I have about 200,000 records to manipulate. I imported a text file into access to accomplish this but I am open to any other suggestions. Thanks in advance for your help.