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
|
|||
|
|||
#Error in Iff statement
I am receiving a #Error message when I change the PName field to the
following =IIf(Len([PName]=2),"-None Selected-",[PName]) in my report. The PName is just a joining of Last and First Name with a comma and space in between. I would like the report to say "-None Selected-" if No Name was entered. Any suggestions? |
#2
|
|||
|
|||
#Error in Iff statement
you have a closing bracket in the wrong place in the LEN function. Try this:
IIf(Len([PName]) =2 ,"-None Selected-",[PName]) John wrote: I am receiving a #Error message when I change the PName field to the following =IIf(Len([PName]=2),"-None Selected-",[PName]) in my report. The PName is just a joining of Last and First Name with a comma and space in between. I would like the report to say "-None Selected-" if No Name was entered. Any suggestions? -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
#Error in Iff statement
|
#4
|
|||
|
|||
#Error in Iff statement
On Nov 13, 1:58 pm, "J_Goddard via AccessMonster.com" u37558@uwe
wrote: you have a closing bracket in the wrong place in the LEN function. Try this: IIf(Len([PName]) =2 ,"-None Selected-",[PName]) John wrote: I am receiving a #Error message when I change the PName field to the following =IIf(Len([PName]=2),"-None Selected-",[PName]) in my report. The PName is just a joining of Last and First Name with a comma and space in between. I would like the report to say "-None Selected-" if No Name was entered. Any suggestions? -- Message posted viahttp://www.accessmonster.com That worked! THANKS! |
Thread Tools | |
Display Modes | |
|
|