6
Reply

select where column value != "0"

Marvin kakuru

Marvin kakuru

Jul 9 2015 5:25 AM
482
hi there,
 
I have an access database "profit" and a column "performance" with negative, positive and zero values. i am trying to select from my table as below.
select from profit where performance != "0"
and
select from profit where performance >< "0"  
but am getting errors 
I want select only where values are greater or less than "0"
any help will be appreciated

Answers (6)