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
|
|||
|
|||
how to use IIF()
I am trying to do a condition where if an address is enter and it is the same
then it will put the value same as above if it is not then it will take the value inputted. Here is my expression: =IIf([POB STREET].AfterUpdate=[HOR STREET].AfterUpdate,"SAME AS ABOVE") |
#2
|
|||
|
|||
how to use IIF()
Is After Update the name of the control or an event?
Bonnie http://www.dataplus-svc.com Roadwarrior1 wrote: I am trying to do a condition where if an address is enter and it is the same then it will put the value same as above if it is not then it will take the value inputted. Here is my expression: =IIf([POB STREET].AfterUpdate=[HOR STREET].AfterUpdate,"SAME AS ABOVE") -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200807/1 |
Thread Tools | |
Display Modes | |
|
|