query returning too many records

  • Thread starter Thread starter stephanie
  • Start date Start date
S

stephanie

I have a query based on 3 tables. It is very similar to
another query I have, also based on 3 tables. The first
one works fine. This second one comes back with about 500
more records than there should be.

Steph from CO
 
Looks like there could be a one to many relationship that
is causing duplication. Are the records all unique? If
not, I would start by determining what records are getting
duplicated.

Rob
 
Post relevant details of your Tables, especially the link Fields and the SQL
String of your Query.
 
Back
Top