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
..
 
Back
Top