I have a table(A)which contains a Well Name, Rig Code, and Rig Seq. I have another table(B) which contains a Well Name and several other fields (but not the Rig Code and Rig Seq). I created a query, linking the two tables by well name, using only the rig code and rig sequence from table A and using the Well Name and other fields from table B. When I run the query, each Well Name and all the data I requested in the query are displayed twice as two separate records. Any idea how I can fix this?

Thanks
Terry

Very strange because I created a database using tables and fields that you provided and did not get any duplicate values when I created the query.

If there are multiple rows with the same WellName in one or both of the tables, your output will appear to be duplicated even though it is technically correct. Try bringing up the query properties and change the UniqueValues property to yes to eliminate the duplicates.