Re: Why does query with linked tables return duplicated data?
- From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
- Date: Thu, 01 Feb 2007 03:48:45 GMT
CMTH wrote:
The table I am including all records from has 27 records. The table
I am joining to has only 15 records. The query is returning a total
of 135 rows. I am using a date range for my criteria, so the same
date can be seen multiple times in the matching table as well as the
all records table.
Those numbers are irrelevent. When you have a query where you display all
records from TableA and matching records from TableB then any duplicates in
TableB will cause you to get duplicates in your output. That will mean an
output with more rows than TableA has.
When I say duplicates in TableB I mean only on the field or fields you are using
in your join. Any other fields could be different.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
.
- References:
- Re: Why does query with linked tables return duplicated data?
- From: Rick Brandt
- Re: Why does query with linked tables return duplicated data?
- Prev by Date: Re: Why does query with linked tables return duplicated data?
- Next by Date: Updating fields from one table to another
- Previous by thread: Re: Why does query with linked tables return duplicated data?
- Next by thread: Updating fields from one table to another
- Index(es):
Relevant Pages
|
