Report with a sub report

[PJ]

I have a report with a subreport. The main report will output clients with
information about that client. The subreport list all the bank involved with
that client. I want to be able to do the following:

If a bank called "ABC Bank" is in the list of a bank in the subreport only
those clients will output. The kicker is I also want subreport to list all
the other banks involved with that cleint.

Any suggestions?

Thanks in advance

 

[Duane Hookom]

The main report's record source would need to be filtered like:

SELECT *
FROM qYourQuery
WHERE ClientID IN (SELECT ClientID FROM tblClientBanks WHERE BankID ="ABC
BANK");

You could also use an JOIN which would probably be more efficient than the
subquery.