Help with query - iff & greater than less then

Q

Qaspec

if field1 is greater than zero and less than 1 than 1 otherwise 0

Whats the right way to write that expression?
 
C

Conan Kelly

QASPEC,

NewCalculatedField: IIF([Field1] > 0 and [Field1] < 1, 1, 0)

HTH,

Conan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Less of Two...but not ZERO 3
Excel Conditioning Formatting 3
Excel Need Countifs Formula Help 0
Selecting records based on time. Example: >07:30:00 AM 2
greater than / less than 11
IF Then with Access 1
query counting issue 4
Returning the existing value 2

Top