Removing Records With Zero Balance

  • Thread starter Thread starter Ty Archer
  • Start date Start date
T

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.
 
Create a calculated field, which is the balance, and filter the report on
this field being >0
 
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.
 
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.
 
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.
Click to expand...


.
Click to expand...
 
Back
Top