Filter Records

[Sir_Hugh]

Good morning,

I have a query to a database, that would only show that the lines in that particular field is different from 0. How can I do this?

Regards

[SoftwareMatters]

Good morning,

I have a query to a database, that would only show that the lines in that particular field is different from 0. How can I do this?

Regards

In the criteria in that column put <> 0 though this won't show up null values if you want to show nulls as well put <> 0 Or Is Null

[Sir_Hugh]

I have another question:
I have a report that I just want the lines to appear on the Final Balance is 0. If the debt - credit is 0, this line does not appear.

Best regards