Zero Balance ...

[Guest]

I have report and I put a text box this text box is sum of two column name as
( No_1 , No_2 ) if the balance of any record = 0 , I want to don’t show this
record
I want give you example :
No_1 , No_2 , Balance
10 ,20 , 30
5 ,-5 , 0
3 , 6 , 9
I want to don’t show this record 5 ,-5 ,0

Help me please , and thank you for try help me .
Thanks and Regards
Farid Sukkar

 

[Douglas J. Steele]

Have your report based on a query, and in the query exclude those rows by an
appropriate WHERE clause.

 

[Guest]

i have a normal report and i add the text box for the balance
the text box in ( control source ) i put this statement ( =([No_1]+[No_2]) )
but i ask you to how can i dont show the record the bance is = 0

Thanks and Regards
Farid sukkar

 

[Douglas J. Steele]

That means that the appropriate WHERE clause in your query would be

WHERE ([NO_1] + [NO_2]) = 0

Actually, to account for floating point round-off errors, you might want to
use something like


WHERE ABS(([NO_1] + [NO_2])) < 0.0001

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

i have a normal report and i add the text box for the balance
the text box in ( control source ) i put this statement (
=([No_1]+[No_2]) )
but i ask you to how can i dont show the record the bance is = 0

Thanks and Regards
Farid sukkar

Have your report based on a query, and in the query exclude those rows by
an
appropriate WHERE clause.