Query is doubling my records


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
 
Ad

Advertisements

D

Dale Fye

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top