I am using Access 2007, and my query adds another set of the same records
every time I open it. How can make the query only include each record once?

Make sure that all tables are joined in the query. If a table with 2 records
is unjoined it becomes a Cartesian product and you get twice as many
records.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"El Cajon Liberty" <El Cajon (E-Mail Removed)> wrote in
message news:1C40A2B2-5CF7-48BA-9853-(E-Mail Removed)...
>I am using Access 2007, and my query adds another set of the same records
> every time I open it. How can make the query only include each record
> once?
>

On Sat, 1 May 2010 13:45:01 -0700, El Cajon Liberty <El Cajon
(E-Mail Removed)> wrote:

>I am using Access 2007, and my query adds another set of the same records
>every time I open it. How can make the query only include each record once?

Please open the query in SQL view and post the SQL text here. We can't fix
what we can't see!
--

John W. Vinson [MVP]

Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"El Cajon Liberty" wrote:

> I am using Access 2007, and my query adds another set of the same records
> every time I open it. How can make the query only include each record once?
>

Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"El Cajon Liberty" wrote:

> I am using Access 2007, and my query adds another set of the same records
> every time I open it. How can make the query only include each record once?
>

Post the SQL of your query.

--
Build a little, test a little.


"El Cajon Liberty" wrote:

> I am using Access 2007, and my query adds another set of the same records
> every time I open it. How can make the query only include each record once?
>

See other reply.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"El Cajon Liberty" wrote:

> I am using Access 2007, and my query adds another set of the same records
> every time I open it. How can make the query only include each record once?
>