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
|
|||
|
|||
How to phrase If/Then clauses in the control source field
Hello,
This is a continuation of an earlier thread about Parsing strings from one field into many. I making a database,that contains five fields of overlap and to make the data entry easier I am trying to automate some of it. I have a code field, and then four other fields whose information can be derived from the code ((codelooks 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).)) Anyway, my problem lies in the fact that the code only has one digit for the year, and the time span is from 1996 to present. so how could one phrase an expression that essentially says: if the first digit of the code string is =6 but =9, add the value to 1990, and if the value is =0 but =5 add it to 2000 (a short term solution; the code thing will eventually be revised). Thanks for any help or info you can provide! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Control source | RJF | General Discussion | 4 | August 4th, 2004 04:32 PM |
NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |
Supress blank lines in DOCPROPERTY field | Mary | Formatting Long Documents | 10 | May 25th, 2004 07:27 PM |
Need help with Control Source usage please... | New Users | 1 | May 20th, 2004 09:59 PM | |
Missing field in data source | AGI | Mailmerge | 1 | May 19th, 2004 10:05 AM |