jeudi 11 juin 2020

Ms access iff fuction in query with symbol <>

I'm using Ms Access 2016. I Have a query as QueryStock like this :

SELECT T_Stock2.Code_Stock, T_Stock2.Stock FROM T_Stock2 WHERE (((T_Stock2.Stock)=IIf([Forms]![F_Stock]![checkbox1]=False,[Stock],[T_Stock2]![Stock]<>0)));

I have a form with checkbox. I want to requery QueryStock after update the checkbox (true or false)

But I have problem with the [T_Stock2]![Stock]<>0. Its not show like I want.

Any idea for the query statement ? Thank you

Aucun commentaire:

Enregistrer un commentaire