How do I express this excel formula so that access can understand it.
=IF(AND(LEFT(C1;2)="no";D1=4525);2001;D1)
How do I express this excel formula so that access can understand it.
=IF(AND(LEFT(C1;2)="no";D1=4525);2001;D1)
Maybe:
=IIf(LEFT([fieldname1],2)="no" AND [fieldname2]=4525, 2001, [fieldname2])
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
=IIif(Left(Your1stValue;2)="no" And Your2ndValue=4525;2001;YourReturnValue)
In case you have Your1stValue starting with either "no" or "NO"
=IIif(UPPER(Left(Your1stValue;2))="NO" And Your2ndValue=4525;2001;YourReturnValue)
In what way "not correct"?But I can't get the return value correct from the 2nd value entry
The only reason for 2nd condition not working properly can be the 2nd value being text instead number.
Or is the value for Your2ndValue not an integer? When this is the case, then
=IIif(UPPER(Left(Your1stValue;2))="NO" And Int(Your2ndValue)=4525;2001;YourReturnValue)
I think that was actually it! I had the data as text. It works now. Many thanks! :-)
In case you have Your1stValue starting with either "no" or "NO"
=IIif(UPPER(Left(Your1stValue;2))="NO" And Your2ndValue=4525;2001;YourReturnValue)
In what way "not correct"?
The only reason for 2nd condition not working properly can be the 2nd value being text instead number.
Access in not case sensitive by default. UPPER() function should not be necessary.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.