Re: Duplicating lines

Without seeing the query there's not much point guessing. Please post
the SQL.

On Tue, 5 Sep 2006 23:00:01 -0700, DaMcH47D
<DaMcH47D@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hello again,

I have a linked text file that contains info from a federal database with
logistical information, price, nomenclature, unit of issue, shelf life codes
etc.. It has a common field NIIN with a table inside the database. This
table has information about the type of part: NIIN, NSN, part number, Supply
Class and system the part is used on. Finally, I have one more table which
lists each part stored in the warehouse by part number, location, qty,
contract number, condition, packaging.

I have a query to list all the stock. Before I created the linked table,
the query would combine the generic part info with the actual part info. I
wanted to add the price and shelf life, so I added in the current linked
table. I have tried to adjust the query, and even created a new query but
always with these same results. Without the linked table there are around
13, 480 items. After I add the linked table, the number increase to 13, 841.
If I look at a table, everything is good, no duplicates. But, If I look at
the query with the linked table, there are several duplicated lines. Remove
the link table from the query and the duplicates disappear. I have tried
breaking the join, started over, changed the join properties. I even tried
builiding a new query. But, if I add that linked table to a querry, the fun
starts. Some info is duplicated in the old tables, but I have not added
those duplicates to the query. Once I get the linked table to function
properly within the query, I will discard the excess info. I have inherited
the database and am trying to make it work without starting over. All other
queries seem to work without any visible errors. Any suggestions would be
greatly appreciated.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

Relevant Pages

  • Re: recordset displaying double entry issue.
    ... I am trying to display my clients ... always tell us what kind and version of database you are using. ... So the question is: are the duplicates ... If your answer is that the tables do not contain duplicates, but your query ...
    (microsoft.public.inetserver.asp.db)
  • Re: Adding auto-numbered field screws up Table order
    ... Append Queries are very simple, and part of the standard methodology ... Access's query designer is one of the great features. ... I know of no desktop database application tool with the equivalent power ... > things, like finding/isolating/deleting duplicates when ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Duplicating lines
    ... but I am a junior but aspiring database ... functionality while cleaning up. ... A very small sample of the datasheet view for the above query with the ... If I look at a table, everything is good, no duplicates. ...
    (microsoft.public.access.externaldata)
  • Re: Deleting duplicate records/same table
    ... append the tblUniqueRecords fields into the fields on tblMaster. ... The new table without the duplicates is called ... Prepared By is the type of query I was ...
    (microsoft.public.access.queries)
  • Re: Query to delete duplicate records - but NOT original
    ... > unique records - I've already got an update query to grab the unique ... > hsc but one other field different - it ignores those 2. ... but this method of removing duplicates requires it. ... >> Access Database Samples: www.rogersaccesslibrary.com ...
    (microsoft.public.access.queries)