Report Criteria

[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

 

[Graham R Seach]

Scott,

You can use the Find Unmatched Query Wizard to build the basic query, and
then modify it to include the specific fields you're looking for.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html