[AccessD] finding duplicates among different departmental programs

The mathematical function you are talking about is XOR.

If you can get a query that looks something like:

Query3:
Person_ID    In_Query_1     In_Query_2
1            True           True
2            False          False
3            True           False
4            False          True

The following query will give you what you want:

SELECT Person_ID
FROM Query3
WHERE (In_Query_1 XOR In_Query_2) = TRUE

The result is the following:

Person_ID
3
4

Scott Marcus
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Clark
Sent: Friday, July 30, 2004 10:58 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] finding duplicates among different departmental
programs


I created a program, about a year and a half ago, for an agency that
deals with providing programs for the elderly. This agency gets its
funding from many different sources and a single source may fund
multiple programs. To track all of this we need to provide many stats.

When this was written, there wasn't a concern about a person being in
multiple programs, although I warned about it. Now, because there state
reporting has changed, there may be a concern. The state is kicking back
their reports because one of their funding counts is greater than the
total amount of participants; there are 1236 people enrolled with the
agency, but one group of programs is showing a count of 1257. I think
the fact that they are even close is a coincidence...I took a sample of
13 members and all but four were in at least 2 of the programs, and
actually my queries, out of necessity, each handle two programs (there
are four for this group) and each one blocks out its own 'duplicates',
so it is very conceivable that many of these people are in all four of
the groups.

Question:

qryOne looks for people in Prog1 OR Prog2 (count = 809)
qryTwo looks for people in ProgA OR ProgB (count = 410)

I need a total count of those is qryOne OR qryTwo 

*** I don't want those that are in both counted twice, which is what a
count of 1219 (809 + 410) 
will give me.

I'm thinking that I need to use one of these queries into another
query...???

Thanks in advance for any help!
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com