Hi!
I have a doubt in my sql statement
It is very simple!
SELECT Loja.Loja, CC.Data, CC.Valor, Cartao.Cartão, CC.[ID Loja], CC.[ID CC]
FROM Loja INNER JOIN (Cartao INNER JOIN CC ON Cartao.[ID CC] = CC.[ID CC]) ON Loja.[ID Loja] = CC.[ID Loja];
What I need is
IF
[ID LOJA] <> 5 , 6 , 7 , 8 or 9
AND
[ID CC] = 4
the [CC.Valor] would show Zero...
How can I do This?? I tried do use an IIF statement but It did not work right! Please help!
I have a doubt in my sql statement
It is very simple!
SELECT Loja.Loja, CC.Data, CC.Valor, Cartao.Cartão, CC.[ID Loja], CC.[ID CC]
FROM Loja INNER JOIN (Cartao INNER JOIN CC ON Cartao.[ID CC] = CC.[ID CC]) ON Loja.[ID Loja] = CC.[ID Loja];
What I need is
IF
[ID LOJA] <> 5 , 6 , 7 , 8 or 9
AND
[ID CC] = 4
the [CC.Valor] would show Zero...
How can I do This?? I tried do use an IIF statement but It did not work right! Please help!