can't exclude zeros from my report

[pampas]

Hi,

I am trying to exclude zeros from my report by setting a report filter
:

[SumOfDebt]-[SumOfCredit] <> 0

This excludes most of the Zeros, but not all.
i have about 60.000 records in the Group query that sums the fields
[Debt] and the field [Credit]

all the fields Debt and Credit, are rounded to 2 decimals

Thanks for your help

Carlos Alvarez

[Randy Harris]

"pampas" <cp*****@hotmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

Hi,

I am trying to exclude zeros from my report by setting a report filter
:

[SumOfDebt]-[SumOfCredit] <> 0

This excludes most of the Zeros, but not all.
i have about 60.000 records in the Group query that sums the fields
[Debt] and the field [Credit]

all the fields Debt and Credit, are rounded to 2 decimals

Thanks for your help

Carlos Alvarez

Carlos, you posted this same message 15 minutes earlier.

[Dean]

Are they rounded in your query? round([debit],2)?

The reason I ask is you may be getting fractions on your report. The
rounding on a report is strickly formatting.

You might try round([SumOfDebt]-[SumOfCredit],2) <> 0

[pampas]

Dean wrote:

Are they rounded in your query? round([debit],2)?

The reason I ask is you may be getting fractions on your report. The
rounding on a report is strickly formatting.

You might try round([SumOfDebt]-[SumOfCredit],2) <> 0

Hi Dean,

Thanks a lot. It worked just fine. I was rounding in the report, not in
the query

Carlos