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
|
|||
|
|||
Vertical Bar error
I have had issue with the vertical bar when building from the expression
builder. The expression builder uses vertical bars but errors when I run the code. If I change it to commas different error but same implied reason. I am not using my commas correctly. Here is code that works (someone else built this, I am trying to reuse)but if I try to add the same code to a new text box the vertical bar error occurs. Is the some sort of reference that I should use to fix this? Help? =IIf(([Request Decision]="Approved")|([CountOfRequest Decision])|"") |
#2
|
|||
|
|||
Vertical Bar error
Try:
=IIf(([Request Decision]="Approved"),([CountOfRequest Decision]),"") Make sure that there is a value in [CountOfRequest Decision] -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "WuiChi" wrote in message ... I have had issue with the vertical bar when building from the expression builder. The expression builder uses vertical bars but errors when I run the code. If I change it to commas different error but same implied reason. I am not using my commas correctly. Here is code that works (someone else built this, I am trying to reuse)but if I try to add the same code to a new text box the vertical bar error occurs. Is the some sort of reference that I should use to fix this? Help? =IIf(([Request Decision]="Approved")|([CountOfRequest Decision])|"") |
Thread Tools | |
Display Modes | |
|
|