One query returns two different recordsets

[Guest]

I have a query to return the 200 addresses shared by 226 people. When I run
the query the first time, it returns duplicate addresses, so that there are
226 rows. If I then sort on any field, the query resets to return 200 rows,
without modifying the SQL statement in any way, and the query returns 200
rows from that point forward.

Unfortunately, whenever I access the query from outside Access (like as the
record source for a mail merge), it returns the 226 rows, with duplicates.

How can I get Access to recognize an INNER JOIN as an INNER JOIN, no matter
what user or application calls the query?

 

[Guest]

Put "SELECT DISTINCT" as the first two words of the SQL statement.

 

[John Spencer]

First, I suggest you post the query you are using.

An INNER JOIN would not normally screen out duplicates. I've seen similar
behavior in the past and I can't recall how I fixed the problem (although I
have a vague feeling that it involved a corrupt index).

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..