Duplicate records are shown in queries window

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Duplicate records are shown in the queries window e.g. if there are 10
records in the main table. 1000 records are shown in the queries windows.
Plz. help to solve the problem
 
AS a guess, you have multiple tables in the query and have not joined them.

So for each combination of records you are getting a row returned.

PLEASE post the SQL of the query you are using. Select View: SQL from the
menu, copy the SQL expression, and post it.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
You must log in or register to reply here.

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

Duplicate Records in a report 4
Report Not Showing All Records 3
Print every other record in a form 13
report creating a fake duplicate 2
Parameter query / check box.. 4
Basic Select Query Duplicating a single end user's records 2
How are duplicates suppressed? 3
Report Sum with Multiple Relationships 2

Back
Top