Multiple records in a query.

G

groffj24

I've created a query that keeps giving me duplicate records when run.
I've looked at it so long that I'm obviously overlooking somethin
thats there that isn't suppose to be.

Can anyone tell me what might be some of the causes for this? Or what
might look for?

Jud
 
J

John Spencer (MVP)

OK, can you copy and post the SQL of your query?

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

This might give us a hint as to your problem.

Are you using more than one table in the query? If so, are the tables joined?
 

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

! 3
Union query producing duplicate records 7
Multiple records in a query 4
deleting duplicate records obtained from a duplicate query 4
Autolookup Query to find Multiple Records 3
Number records in a query 6
Repeating records in Query 20
remove duplicate records in Access 2007 7

Top