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
|
|||
|
|||
Complicated IIf Statement
I have records that contain 3 fields named, "SA1", "SA2",
and "SA3". I want to create a calculated field that will look at these three fields and if any of them contain the value, "FF" then have the new calculated field value be "FF". Any help is greatly appreciated as always. Thankyou. mate. |
#2
|
|||
|
|||
Complicated IIf Statement
What do you want the result to be if none of the fields
has the value "FF"? -----Original Message----- I have records that contain 3 fields named, "SA1", "SA2", and "SA3". I want to create a calculated field that will look at these three fields and if any of them contain the value, "FF" then have the new calculated field value be "FF". Any help is greatly appreciated as always. Thankyou. mate. . |
#3
|
|||
|
|||
Complicated IIf Statement
It could be anything i suppose. lets say "NO SACODE"
-----Original Message----- What do you want the result to be if none of the fields has the value "FF"? -----Original Message----- I have records that contain 3 fields named, "SA1", "SA2", and "SA3". I want to create a calculated field that will look at these three fields and if any of them contain the value, "FF" then have the new calculated field value be "FF". Any help is greatly appreciated as always. Thankyou. mate. . . |
#4
|
|||
|
|||
Complicated IIf Statement
disregard my other reply. is there a way to have the
field be blank if none of teh fields has the value "FF" -----Original Message----- What do you want the result to be if none of the fields has the value "FF"? -----Original Message----- I have records that contain 3 fields named, "SA1", "SA2", and "SA3". I want to create a calculated field that will look at these three fields and if any of them contain the value, "FF" then have the new calculated field value be "FF". Any help is greatly appreciated as always. Thankyou. mate. . . |
#5
|
|||
|
|||
Complicated IIf Statement
Field: HasFF: IIF(Sa1="FF" Or Sa2 ="FF" Or SA3 = "FF", "FF",Null)
An alternative that may work Field: HasFF: IIF("FF" in (Sa1,Sa2,Sa3),"FF", Null) mate wrote: disregard my other reply. is there a way to have the field be blank if none of teh fields has the value "FF" -----Original Message----- What do you want the result to be if none of the fields has the value "FF"? -----Original Message----- I have records that contain 3 fields named, "SA1", "SA2", and "SA3". I want to create a calculated field that will look at these three fields and if any of them contain the value, "FF" then have the new calculated field value be "FF". Any help is greatly appreciated as always. Thankyou. mate. . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
If statement | Doug | Worksheet Functions | 4 | June 25th, 2004 01:42 PM |
Access 2000 query SQL statement into VBA code | Clint | Running & Setting Up Queries | 1 | June 10th, 2004 01:33 PM |
help with IF statement | Aladin Akyurek | Worksheet Functions | 0 | March 3rd, 2004 08:54 PM |
multiple arrays in single statement | Alan Beban | Worksheet Functions | 2 | November 21st, 2003 12:34 PM |
if statement - text / blank cell | jester | Worksheet Functions | 5 | November 3rd, 2003 01:28 AM |