append query repeats some lines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there, i've written a database that takes input from an external source
and prepares it for use within our business. If say I import 400 records 380
will import normally and the last 20 or so will repeat themselves many times.
It may be that my logic (the list is created from other queries) is wrong -
what I'd like to do (instead of drilling into the prior queries which were
very complex to set up) is to know who to stop a field and its associated
records repeating itself. ie:

CoName Add1 Add2 Add3
ABC 1 2 3 (normal line)
DEF 4 5 6
DEF 4 5 6 (repeating line - can repeat
between 5 - 10 times)
 
Add the data to a temporary table, and use a SELECT DISTINCT query to
retrieve the data from that temporary table for insertion into your real
table.
 
Hi doug, thanks for this. It works on the CoName field but when I later add
the other fields (which include a memo field) I receive "field too small". I
tested this by just doing a SELECT DISTINCT on the memo field and proved that
this is where the problem lies. ie SELECT DISTINCT on the CoName alone gives
me just one instance of each record but if I then add the memo field to the
query it all falls over.
 
Back
Top