If and Query

[KarenWilson]

Hello


I want to create a query in which 2 criteria need to be meet
I need the query to say if Stock is null and repair is >0 then stock = 05* repair
Thanks for any help you are able to give
Karen

[NoellaG]

Hi Karen

try something like

Iif(Nz([Stock],0) = 0 and [Repair] > 0, [Repair] * 5,0)

NG

[KarenWilson]

Thanks
Works with an added else statement fine
Karen