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

J

Jim

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
 
D

Duane Hookom

Since this is a query NG, I assume you want to create a column like:
NewColumn: IIf([X]<0,0,[X])
 
B

Bob Miller

Place this in your query:
IIf([Num]<0,0,[Num]) AS NewNum
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
Click to expand...
 
Top