Conditional tests in Access Reports

[Guest]

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

 

[RBear3]

Just change the query so that it only pulls values greater than zero.

 

[Guest]

Perhaps my example wasn't detailed enough:

Let's say there are three facilities: Main Office, Outpost 1 and Outpost 2

Fred, Joe and Charlie derive income from each facility but in any given
reporting period they may or may not receive income from a facility:

Main Office

Fred's Income $500.00
Joe's Income $0.00
Charlie's Income $200.00

Outpost 1

Fred's Income $0.00
Joe's Income $100.00
Charlie's Income $200.00

Outpost 2

Fred's Income $1000.00
Joe's Income $300.00
Charlie's Income $0.00

The report is set up so that each facility prints as a page.

There are conditions associated with the records, for instance

Main office might be "show all income"
Outpost 1 may be "show only positive income"
Outpose 2 may be "show all income"

So on the page that represents Main Office the report should print, based on
the above condition

Fred's Income $500.00
Joe's Income $0.00
Charlie's Income $200.00

The page that represents Outpost one, where the condition is "show only
positive income"

Joe's Income $100.00
Charlie's Income $200.00

and Outpost 3 would print becsuae the condition is "show all income"

Fred's Income $1000.00
Joe's Income $300.00
Charlie's Income $0.00

Do I have to create separate reports for each condition and have the
conditional test appear in a macro or is there a way to apply the condition
within the report itself?