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 wrote in
message ...
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?