asked on

Hiding portions of records in a report

Not sure if the title is completely descriptive of what I want to do, but.......I have a report with two header levels (Job number and Ability). In the details section of the report, I want to be able to filter records on a certain criteria (if an importance rating is > 2). When I set the criteria, sometimes there aren't any importance ratings for a particular ability. Of course, Access filters abilities that aren't linked with importance ratings > 2. I was wondering if there would be a way to programmatically tell Access if an importance rating is > 2, don't show the details section for that record, but show the two header levels. So, for example, Let's say that 11-0000.00 is the job number (plumber) and Concentration is the ability. If there aren't any importance ratings > 2 for the Concentration ability, how do I tell access to blank the details section of the report, but to display 11-0000.00 and Concentration. Here's a snapshot of a report:

11-0000.00

Concentration:
_____________
Importance = 3
Importance = 4
Importance = 5
Importance = 4

I can filter out the 2's with no problem, but when no importance rating is > 2, Access filters the ability as well.

Thanks for your help.

ASKER CERTIFIED SOLUTION

Y2Chris75

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Feyo

ASKER

It's actually a bit more complicated. Here is a sample table structure:

Job number Ability Importance
1 Concentration 3
1 Writing 2
2 Concentration 2
2 Writing 4

I was able to fix the problem by creating a job number by ability query (by grouping), then using that query for a main report in which I linked two subreports by those fields.

Thanks for the response.