The Database Forum

**GemmaLouise1988** · 12-04-2007, 10:27 AM

hello

i am trying to get my database so that if the number in a column = to 0 or below it will then display out of stock

so far i have got this but it wont work

=IIf([quantity]="0","out of stock")

**hamesy** · 12-04-2007, 10:35 AM

A little more information would be useful, ie what database are you using? What language are you using? etc.

You might get a few more replies if you add more information.

**GemmaLouise1988** · 12-04-2007, 10:38 AM

i am using microsoft excel 2000

**GemmaLouise1988** · 12-04-2007, 10:38 AM

ooops sorry

i mean microsoft access 2000

**chrishirst** · 12-04-2007, 03:09 PM

"0" is a string which != 0 (zero)

**Learning Newbie** · 12-04-2007, 06:41 PM

I was about to say what Chris said. If it's a number column, the db will probably do an implicit conversion to make it work, but "0" != 0.

Also, it's clear this is Access, because SQL Server supports the if statement, but not iif.

If this is for a web application, you're better off just returning quantity to the page and letting it decide what text to send down to the client.