Marvin kakuru

Marvin kakuru

  • 1.1k
  • 355
  • 160.1k

select where column value != "0"

Jul 9 2015 5:25 AM
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)