Report Criteria

message from Scott on 5 May 2004

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 replied to Scott on 6 May 2004

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

"Scott" <anonymous@discussions.microsoft.com> wrote in message
news:8f7301c4330b$4683b4f0$a601280a@phx.gbl...

Archived message: Report Criteria (MS Access Forms)