If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Strings: Parsing data into other fields in the same table
I am making a simple database and I was wondering how can
the information from a field containing strings of both numbers and characters be broken and entered other fields. I am dealing with a code that looks like this: 01MP, and has four parts. The first number refers to the year 2000, the second number refers the season of the year (spring), the third to type of media (a magazine), and the fourth the genre (politics). I have a field for the code and fields for each of the four parts but I was wondering how I could automate the entry of the four extra fields as the data is redundant. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to extract original data from a pivot table? | cmagnus98 | General Discussion | 1 | July 9th, 2004 03:55 PM |
Trying to break up data in the label format to fields, for easy entry into table | Visali | Mailmerge | 1 | June 7th, 2004 10:35 PM |
Combining data from multiple fields into Pivot table | Os | Worksheet Functions | 5 | June 1st, 2004 05:04 PM |
HELP: Update 1 table with calculated fields from another table | Samora | Running & Setting Up Queries | 0 | May 23rd, 2004 05:16 PM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |