AnsweredAssumed Answered

Prepare report from master and dependent table using only certain rows from dependent table

Question asked by datadog1 on Nov 16, 2009
Latest reply on Nov 16, 2009 by philmodjunk

Title

Prepare report from master and dependent table using only certain rows from dependent table

Post

I would like tips on how to build a report with fields from a master table and fields from a dependent table where the rows displayed from the dependent table are only those meeting certain criteria.  For example, the master table contains subscribers; the dependent table contains begin and expire dates of subscriptions.  A subscriber may have had several subscriptions over the years, but can only have one has not expired--which is indicated by the expire date being greater than today's date.  I would like help in developing a report which would include the subscriber name from the master record and the Max(ExpireDate) from the dependent record if and only if the Max(ExpireDate) from the set of matching rows in the dependent table is earlier than today's date.

Outcomes