Query Statement for negative values = 0 but keep the whole values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Would any know how I can use a query statement that express if the values = a
negative value change the value to zero if know keep the whole value.

Example: I would like -1000 to be 0
But 1000 to be 1000

Ive been trying something like =IIf ([X]<0, 0)

In column X are values 1000, 2000, -2000
 
Since this is a query NG, I assume you want to create a column like:
NewColumn: IIf([X]<0,0,[X])
 
Back
Top