calcuation between 2 numbers and given result

[Ben Ball]

Hi,

 

I am trying to sort a calculation which is solved by the following.

"field a" has a range between 0001 and 9999

so if "field a" is between 0001 and 0999 I need to give field b a result of "yes"

 

i tried this. 

If ( fieldA ≥ 1 & fieldA ≤  999; "yes"; "" ) but it did'nt work.

[comment]

36 minutes ago, Ben Ball said:

If ( fieldA ≥ 1 & fieldA ≤  999; "yes"; "" ) but it did'nt work.

"it did'nt work" is not a good description of a problem. What does fieldA contain, and what is the result you get? 

Also, is fieldA defined as a Number field? You say it "has a range between 0001 and 9999". Numbers do not have leading zeros - and if you want to compare a text value to a number, you must convert it to a number first.

 

Edited September 24, 2019 by comment

[Ben Ball]

Yes ok.. apologise if it was unclear, but  I did write that field A contains values between 1 and 9999

I now know why it did'nt work. I should have written "and" not &.

the returned value would be 1 then, not yes.

 

thanks for the comment..