Removing Records With Zero Balance

[Ty Archer]

I'm printing a report that subtracts an opening balance
from and ending balance. If the balance is zero I don't
want that record to show on the report. Can anyone give me
a way to not show the zero balance records. Thanks very much.

 

[SteveJ]

Create a calculated field, which is the balance, and filter the report on
this field being >0

 

[Ty Archer]

I have created the calculated field, however, I don't know
how to filter based on this field. Please help. Thanks
very much in advance.

 

[SteveJ]

In the report's Properties->data tab there is a filter field. Insert
[Balance]>0 (or whatever the field name is) and make sure the Filter On
field is set to Yes.

Alternatively, in the record source field you can append "WHERE [Balance] >
0" to the SQL statement.

 

[Jim/Chris]

Do the calculation in a query that the report is based on.
In the criteria for that field but >0

Jim

-----Original Message-----
In the report's Properties->data tab there is a filter field. Insert
[Balance]>0 (or whatever the field name is) and make sure the Filter On
field is set to Yes.

Alternatively, in the record source field you can append "WHERE [Balance] >
0" to the SQL statement.

I have created the calculated field, however, I don't know
how to filter based on this field. Please help. Thanks
very much in advance.

.