D
Don in K-Town
I create a report from a query. I want the report to print ONLY those fields
with positive values. If the field value is zero I want the report to not
print that field or the caption associated with it. How do I set a
conditional test in the report to do this.
Eg:
In the Query you get the following
Fred's Income $10,000.00
Joe's Income $ 0.00
Charlie's Income $15,000.00
On the report I want it to appear as:
Fred's Income $10,000
Charlies Income $10,000
with positive values. If the field value is zero I want the report to not
print that field or the caption associated with it. How do I set a
conditional test in the report to do this.
Eg:
In the Query you get the following
Fred's Income $10,000.00
Joe's Income $ 0.00
Charlie's Income $15,000.00
On the report I want it to appear as:
Fred's Income $10,000
Charlies Income $10,000