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).]