Selection Formula Where All Joined Records Satisfy Criteria

[nickolsen]

I have two tables, Unit and Resident. I am trying to create a report that shows the available units. I have added the two tables to the report with a inner join connecting the two tables. It is a one to many relationship from Unit to Resident (more than one resident for each unit). On the Resident table there is a field called NoticeGiven. I am selecting based upon the Unit table. My problem is I only want to show a unit in the report if every resident associated with the Unit has True in the NoticeGiven field.

For example, you have the following:

Unit
Resident - Notice Given

100
Jason - True
Wilson - True

200
Andres - True
Thomas - False

300
William - False

The report should show:

100
200


How can I do this?

[jawadhashmi]

check for the count in help.

[nickolsen]

Can you use count in the selection formula?? and if so, how?

[jawadhashmi]

I don't think you can use the Count in selection formula.

But you can use it in the group header/detail section to show or suppress that section.

can you upload the sample report saved with data ?