Stop a query

D

Diogo

I'm using the following query to append a result if there is no result for
that date, else it appends a zero. instead I would like it to stop if there
is a result for that day.
how do I do that? Thanks.

INSERT INTO Numerario ( Numerario )
SELECT IIf((SELECT Numerario.Numerario
FROM Numerario
WHERE (((Numerario.Data)=Date()))) <> NULL, 0
IIf(numerario_anterior!Numerario<0,(z3!SOMATÓRIO1-z2!SOMATÓRIO2)+numerario_anterior!Numerario,(z3!SOMATÓRIO1-z2!SOMATÓRIO2))) AS Numerario
FROM z2, z3, numerario_anterior;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top