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
|
|||
|
|||
displaying data in expression builder
I'm working with a table that has abbreviations for longer items (for
example, "P", "E", "S", and "C" = the P means Professional). I know I've done this before, but can't figure it out. Was hoping to create an unbound text box in my form that actually shows the longer display (i.e., if the field "CATEGORY" = "P", it shows "Professional" instead). I currently tried: =If([Category]="P","Professional (Non-Equity)",if([Category]="E","Union (Equity)",if([Category]="S","Academic",if([Category]="C","Non-Professional")))) and it's giving me a #Name? error. I've tried taking out the quotes, moving them to single quotes, quoting the field name instead of the brackets, nothing helps. Can someone jog my memory? |
#2
|
|||
|
|||
displaying data in expression builder
replace the if for iif that should do the trick:
=Iif([Category]="P","Professional (Non-Equity)",iif([Category]="E","Union (Equity)",iif([Category]="S","Academic",iif([Category]="C","Non-Professional")))) -- Maurice Ausum "BakaBard" wrote: I'm working with a table that has abbreviations for longer items (for example, "P", "E", "S", and "C" = the P means Professional). I know I've done this before, but can't figure it out. Was hoping to create an unbound text box in my form that actually shows the longer display (i.e., if the field "CATEGORY" = "P", it shows "Professional" instead). I currently tried: =If([Category]="P","Professional (Non-Equity)",if([Category]="E","Union (Equity)",if([Category]="S","Academic",if([Category]="C","Non-Professional")))) and it's giving me a #Name? error. I've tried taking out the quotes, moving them to single quotes, quoting the field name instead of the brackets, nothing helps. Can someone jog my memory? |
#3
|
|||
|
|||
displaying data in expression builder
Just a noob here, but isn't the function "IIF" (not "If")?
-Ron "BakaBard" wrote in message ... I'm working with a table that has abbreviations for longer items (for example, "P", "E", "S", and "C" = the P means Professional). I know I've done this before, but can't figure it out. Was hoping to create an unbound text box in my form that actually shows the longer display (i.e., if the field "CATEGORY" = "P", it shows "Professional" instead). I currently tried: =If([Category]="P","Professional (Non-Equity)",if([Category]="E","Union (Equity)",if([Category]="S","Academic",if([Category]="C","Non-Professional")))) and it's giving me a #Name? error. I've tried taking out the quotes, moving them to single quotes, quoting the field name instead of the brackets, nothing helps. Can someone jog my memory? |
Thread Tools | |
Display Modes | |
|
|