IF Then with Access

G

Guest

Can a new Field be created that would be 1 if FieldA is less than zero, 0 if
greater than or equal to zero ?

Thank you in advance.
 
T

Tom Lake

carl said:
Can a new Field be created that would be 1 if FieldA is less than zero, 0
if
greater than or equal to zero ?
Click to expand...

Yes.

IIf([FieldA] < 0, 1, 0)

Tom Lake
 

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

quandary on selecting certian records 4
Populate entire field in query with the value of a cell 6
Help with query - iff & greater than less then 1
Excel Need Countifs Formula Help 0
Exclude Multiple Zeros in Query 4
Query 2
Calculated Field 2
Need your help 5

Top