Basic Select Query Duplicating a single end user's records

  • Thread starter Thread starter Guitarzann
  • Start date Start date
G

Guitarzann

I am stumped with a particular problem. My table consists of hundreds of
records that are directed to their associated end user. This is my simple
Select query shown here:
"SELECT [Name Tbl].Mgr, [Name Tbl].Name, [Data Tbl].Survey_CNT,
FROM Manager INNER JOIN ([Name Tbl] INNER JOIN [Data Tbl] ON [Name Tbl].ID#
= [Data Tbl].Name) ON Manager.OM = [Name Tbl].Mgr"

Inside the Data Tbl, one Name shows 4 physical records. However, in this
simple query it has duplicated one Name's records so now there is 8 for that
one particular name.

The other Names show a correct matching count of records between the Data
Tbl and the query. What could be the cause of why this query is duplicating
just one Name's data? What baffles me is there are no mathematical processes
in the query; just a simple SELECT query.

Thanks
 
Guitarzann -

Are there two managers associated with that table? That would double the
records returned for that table.
 
Thanks Daryl, I discovered a "Duh" on my part. It was not a duplicate
Manager. It turned out to be another Name with a slight variation of the
spelling of their name. The Name Tbl needed to be modified to distinguished
the two. My eyes missed the single letter.

My apologies for missing that one! :(

Daryl S said:
Guitarzann -

Are there two managers associated with that table? That would double the
records returned for that table.

--
Daryl S


Guitarzann said:
I am stumped with a particular problem. My table consists of hundreds of
records that are directed to their associated end user. This is my simple
Select query shown here:
"SELECT [Name Tbl].Mgr, [Name Tbl].Name, [Data Tbl].Survey_CNT,
FROM Manager INNER JOIN ([Name Tbl] INNER JOIN [Data Tbl] ON [Name Tbl].ID#
= [Data Tbl].Name) ON Manager.OM = [Name Tbl].Mgr"

Inside the Data Tbl, one Name shows 4 physical records. However, in this
simple query it has duplicated one Name's records so now there is 8 for that
one particular name.

The other Names show a correct matching count of records between the Data
Tbl and the query. What could be the cause of why this query is duplicating
just one Name's data? What baffles me is there are no mathematical processes
in the query; just a simple SELECT query.

Thanks
Click to expand...
Click to expand...
 
Back
Top