Rolling Information Up from Detail to Header 1

[perrymans]

I have a Pass/Fail field in the both the header and the footer.

The header field is unbound.
The detail field is bound.

I want the following logic:

1. If All PassFail in Detail = Pass Then PassFail in Header = Pass.
2. If Any records in PassFail in Detail = Fail Then passFail in Header = Fail.

How can this be done? Thanks. Sean.

 

[pbaldy]

This feels like a kludge but should work:

=IIf(Sum(IIf([PassFail]="Pass",1,0))=Count([PassFail]),"Pass","Fail")


Paul
MS Access MVP 2007/2008

 

[perrymans]

Works perfectly!

Thanks. Sean.