Main Report Records

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a main report that has a subreport on it; I want
the main report to display *only* those records who have
a match in the child field on the subreport, is there any
way how to get it.?

Thanks


Scott
 
Sure thing
Create the Recordsource Query like this:
SELECT .... FROM MAINTABLE A WHERE EXISTS (SELECT 'X' FROM SUBTABLE B WHERE
B.LINKFIELD = A.MASTERFIELD)

HTH

Pieter
 
Back
Top