Displaying only values needed

In Access2000 frontend, SQL server backend. I have a report based on a view which asks for a True to appear if a specified "task" needs to be done, and False if it doesn't need to be done. Any task that does not need to be done will have a false value, and the false value is not visible. This all works fine.

However, I have been asked that if a value is false, that the entire record not be visible on the report. The user only wants "Jobs" that have a True value to be visible on the report.

There are several fields in this report which could be True / False. I have tried putting = True as critera in each of the fields in order that I only receive the "True" values and no "False" values. However, this only gives me the True values for an individual field and not all. Please see the below example.

JOB NUMBER
2800

SHRINKWRAP
True

DRILLING
False

ADHERE DISK
False

-----------------------------

JOB NUMBER
2801

SHRINKWRAP
False

DRILLING
False

ADHERE DISK
False

-----------------------------

In the above examples, Job Number 2800 would be visible on the report as there is a True value in one of the required fields. Job Number 2801 would not be visible as all values are False.

I hope this isn't to confusing.

Thanks,
Gary

Add to you SQl statement (know we have talked about the True False switch before) a where clause that will only show a record where
((SHRINKWRAP = true) or (DRILLING = true) or (ADHERE DISK = true))

S-