How do I express this formula?

[Essmoll]

How do I express this excel formula so that access can understand it.


=IF(AND(LEFT(C1;2)="no";D1=4525);2001;D1)

[June7]

Maybe:

=IIf(LEFT([fieldname1],2)="no" AND [fieldname2]=4525, 2001, [fieldname2])

[ArviLaanemets]

=IIif(Left(Your1stValue;2)="no" And Your2ndValue=4525;2001;YourReturnValue)

[Essmoll]

That's what I tried but it gives me an error on all posts where filedname 1 is "NO".

Maybe:

=IIf(LEFT([fieldname1],2)="no" AND [fieldname2]=4525, 2001, [fieldname2])

[Essmoll]

But I can't get the return value correct from the 2nd value entry.

=IIif(Left(Your1stValue;2)="no" And Your2ndValue=4525;2001;YourReturnValue)

[ArviLaanemets]

In case you have Your1stValue starting with either "no" or "NO"
=IIif(UPPER(Left(Your1stValue;2))="NO" And Your2ndValue=4525;2001;YourReturnValue)

But I can't get the return value correct from the 2nd value entry

In what way "not correct"?
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)

[Essmoll]

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.

[June7]

Access in not case sensitive by default. UPPER() function should not be necessary.