Bill Something like this may work for you, just change to Print ... select custnum,f_name,L_name from ptinfo where custnum in (select custnum from tran_hist where tr_date > 1/1/05)
Marc From: Bill Niehaus Sent: Wednesday, May 27, 2009 2:32 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Selection criteria based upon sub-reports Is there a way to select records that print based upon the table in the main report as well as the table in the sub report? I can get records from the main table by using a condition in a WHERE clause, but don't know how to select based upon columns in the sub report. Using V8. Thanks. Bill Niehaus
