Too many showing in query

  • Thread starter Thread starter DebbieSue
  • Start date Start date
D

DebbieSue

I am combinding a query and a table to create one query. My table are
addresses and my query are the people I need to mail to. The common
denominator is the Law Firm name in each. When I run the report I get
multiples of one person. I have tried to double click the connection line and
told it to take everything from the query and only those matching from the
table, but it does not work. I have also tried to filter it by unique values
and records, still doesn't work. I'm hoping someone can help me out on this.
I have been able to fix it in the past, but not this time.
 
I am combinding a query and a table to create one query. My table are
addresses and my query are the people I need to mail to. The common
denominator is the Law Firm name in each. When I run the report I get
multiples of one person. I have tried to double click the connection line and
told it to take everything from the query and only those matching from the
table, but it does not work. I have also tried to filter it by unique values
and records, still doesn't work. I'm hoping someone can help me out on this.
I have been able to fix it in the past, but not this time.
Click to expand...

Are there multiple records in either (or both) tables for the law firm? You
will get multiples if the law firm name occurs multiple times in either table;
even more multiples if it occurs multiple times in both tables.

Please open your query in SQL view and post the SQL text here, and indicate
which (if either) table has a unique value for the joining field.

Do note that a law firm name is a VERY BAD choice of primary key (joining
field); a Primary Key should be unique, stable, and short, and a business name
fails on all three counts. You may want to reexamine your tables'
normalization!
 
Back
Top