Report Criteria

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

Scott

I have a database where I manage membership for a
organization, there are 2 tables in there, 1 called
Membership_Records which contains the info for each
family who enrolls in the membership, and the second
table is called Members which contain each individual who
registers as a member, the Membership_ID is the same for
each member in the family, additionally each member has
code to define what she/he is, a father, mother, child,
now let say father is coded as 'F' and mother is coded
as 'M' I want to produce a report that will show me each
record in the Membership_Records table that does not have
both 'M' and 'F' as registered members, can anyone help. ?


Thanks,

Scott
 
Back
Top