Duplicates in Query
From: Mel (Mel_at_discussions.microsoft.com)
Date: 02/16/05
- Next message: HBS: "Re: need an analysis tool..."
- Previous message: Lin: "Re: Keyfield and fields"
- Next in thread: DebbieG: "Re: Duplicates in Query"
- Reply: DebbieG: "Re: Duplicates in Query"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 16 Feb 2005 13:59:04 -0800
I'm designing a query from two tables (Administrators and Budget) where I
need to
generate a combined list of email addresses. I have several people in my
Administrators table who have more than one record/unique ID because they
belong to multiple departments.
When I run the query, I either get results where each email address from the
Budget table duplicates to match each record from the Administrator's table.
This occurs when I've selected Unique Records "Yes" in the Query Properties.
When I select Unique Values "Yes", then the Administrator's email addresses
multiply to match each record from the Budget table.
I end up with 1000s of records rather than just 80.
So, how do I fix the query to prevent the data from multiplying? Also, how
do I query so that I don't get the same name with different unique IDs (Admin
table) from popping up?
-- Thanks, Mel
- Next message: HBS: "Re: need an analysis tool..."
- Previous message: Lin: "Re: Keyfield and fields"
- Next in thread: DebbieG: "Re: Duplicates in Query"
- Reply: DebbieG: "Re: Duplicates in Query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
