Query is doubling my records

  • Thread starter Thread starter Dustin
  • Start date Start date
D

Dustin

I have a query in Access 2000 that gets all the data I
want it to get. The problem, however, is that it brings
every one of those records into the query twice. So if
the query is only supposed to bring in 8 records, it'll
bring in those 8 twice, for 16 records. Furthermore, I
have two of the fields in the query as parameters that the
user must enter for the query to work. If the second
parameter is NOT empty, it doesn't do the duplication
thing. If it is empty, it will duplicate the records.
Thanks in advance for any help
 
Dustin,

Post your SQL string.

The duplicate problem is most likely the result of you joining 2
tables together based on a userid or some other common field, and
having more than one of each userid in the second table (a one to many
relationship). To find out if this is the case, create a "Find
Duplicates" query using the query wizard.

--
HTH

Dale Fye


I have a query in Access 2000 that gets all the data I
want it to get. The problem, however, is that it brings
every one of those records into the query twice. So if
the query is only supposed to bring in 8 records, it'll
bring in those 8 twice, for 16 records. Furthermore, I
have two of the fields in the query as parameters that the
user must enter for the query to work. If the second
parameter is NOT empty, it doesn't do the duplication
thing. If it is empty, it will duplicate the records.
Thanks in advance for any help
 
Back
Top