Help with query - iff & greater than less then

  • Thread starter Thread starter Qaspec
  • Start date Start date
Q

Qaspec

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

Whats the right way to write that expression?
 

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

Excel Conditioning Formatting 3
Less of Two...but not ZERO 3
Excel Need Countifs Formula Help 0
Selecting records based on time. Example: >07:30:00 AM 2
quandary on selecting certian records 4
IF Then with Access 1
Iif Query 5
Returning the existing value 2

Back
Top