JHMarshIII
Registered User.
- Local time
- Today, 00:43
- Joined
- Feb 8, 2002
- Messages
- 19
How do I test the count of related records in the many side table?
I have two tables, Members and DuePmts joined on MemberID. Members have a 1-to-many relationship to Duepmts. As payments are posted to DuePmt records, a new ExpireDT assigned.
What I need to do is create a query (to drive a report) that can id, show the details, and counts of only the "new" members and sometimes both.
New members have only one record in the related table and an ExpireDT > Now(). So I can't just choose the max(ExpireDT). I also need to count the number of records in the related table to see which MemberIDs have only one record.
How do I do that and combine the two criteria? Is the right approach?
Thanks, John ...
-----------------
[This message has been edited by JHMarshIII (edited 04-15-2002).]
[This message has been edited by JHMarshIII (edited 04-15-2002).]
I have two tables, Members and DuePmts joined on MemberID. Members have a 1-to-many relationship to Duepmts. As payments are posted to DuePmt records, a new ExpireDT assigned.
What I need to do is create a query (to drive a report) that can id, show the details, and counts of only the "new" members and sometimes both.
New members have only one record in the related table and an ExpireDT > Now(). So I can't just choose the max(ExpireDT). I also need to count the number of records in the related table to see which MemberIDs have only one record.
How do I do that and combine the two criteria? Is the right approach?
Thanks, John ...
-----------------
[This message has been edited by JHMarshIII (edited 04-15-2002).]
[This message has been edited by JHMarshIII (edited 04-15-2002).]
