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
|
|||
|
|||
Help with syntax
I need the correct syntax for using IIf with Or in a form. What I currently
have isn't working: =IIf([cboInvoiceNumber].[Column](16)="SH3700" Or If([cboInvoiceNumber].[Column](16)="SU8035",[cboInvoiceNumber].[Column](9),[cboThirdPartyBilling].[Column](1)) Thanks Jim |
#2
|
|||
|
|||
Help with syntax
Jim,
You don't need the second if. It should look like this: =IIf([cboInvoiceNumber].[Column](16)="SH3700" Or [cboInvoiceNumber]. [Column](16)="SU8035",[cboInvoiceNumber].[Column](9),* [cboThirdPartyBilling].[Column](1)) You can also try using IN =IIf([cboInvoiceNumber].[Column](16) in("SH3700", "SU8035") , [cboInvoiceNumber].[Column](9),*[cboThirdPartyBilling].[Column](1)) Rob Buonocore InfoCore On Aug 26, 1:21*pm, "Jim" wrote: I need the correct syntax for using IIf with Or in a form. What I currently have isn't working: =IIf([cboInvoiceNumber].[Column](16)="SH3700" Or If([cboInvoiceNumber].[Column](16)="SU8035",[cboInvoiceNumber].[Column](9),*[cboThirdPartyBilling].[Column](1)) Thanks Jim |
#3
|
|||
|
|||
Help with syntax
Hi Jim,
Try: =IIf([cboInvoiceNumber].Column(16)="SH3700" Or [cboInvoiceNumber].Column(16)="SU8035",[cboInvoiceNumber].Column(9),[cboThirdPartyBilling].Column(1)) Clifford Bass "Jim" wrote: I need the correct syntax for using IIf with Or in a form. What I currently have isn't working: =IIf([cboInvoiceNumber].[Column](16)="SH3700" Or If([cboInvoiceNumber].[Column](16)="SU8035",[cboInvoiceNumber].[Column](9),[cboThirdPartyBilling].[Column](1)) Thanks Jim |
#4
|
|||
|
|||
Help with syntax
Thanks!
"Clifford Bass" wrote in message ... Hi Jim, Try: =IIf([cboInvoiceNumber].Column(16)="SH3700" Or [cboInvoiceNumber].Column(16)="SU8035",[cboInvoiceNumber].Column(9),[cboThirdPartyBilling].Column(1)) Clifford Bass "Jim" wrote: I need the correct syntax for using IIf with Or in a form. What I currently have isn't working: =IIf([cboInvoiceNumber].[Column](16)="SH3700" Or If([cboInvoiceNumber].[Column](16)="SU8035",[cboInvoiceNumber].[Column](9),[cboThirdPartyBilling].[Column](1)) Thanks Jim |
#5
|
|||
|
|||
Help with syntax
Hi Jim,
You are welcome! Clifford Bass "Jim" wrote: Thanks! |
Thread Tools | |
Display Modes | |
|
|