IF Then with Access

C

carl

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

Mail Merge Switch - Dollars to Words 0
query criteria eliminates too many record results 1
quandary on selecting certian records 4
Use TODAY() function as the criteria in a SUMIF formula 1
Greater Less or Equal 3
Populate entire field in query with the value of a cell 6
Exclude Multiple Zeros in Query 4
Help with query - iff & greater than less then 1

Top