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?