Criteria for filtering dupe records?

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

Guest

I want to run an append query but have it filter out the duplicate Product ID
numbers and only show the first one if more than one exist. The first one is
the most current so I want to append all data from one source table to the
tagret table and if there is dupes only append the first one in the record
set. Is there creteria for this>
 
You would need a date field or some such information to set criteria.

You could set the Product ID of the tartget table to unique and it would
only accept one Product ID and none that matched an existing record.
 
OK I have the target table that has the product ID set to no dupes and my
source table has the same primary key. In the same table I do have another
field that is also set with a key and it is a date field. Would that work? I
have tried it and I get a key violation error.
 
The key violation just says it attempted to append a second record with the
same Product ID - no problem.
 
This database is a total mess. The guy who wrote this aught to be shot. The
company that hired me to fix this mess will not allow me to adjust any of the
property settings. They said the IT department will not allow it because it
is on a SQL server. I understand that but do they want it to work or not.?
Because I can not touch the properties do you know of any work around? I was
thinking of a filter to only accept the first record then base the update
query off that. I did a temp one fbut the thing keeps reading the data from
the target table and not the source. What a mess! If you have any suggestions
please feel free. Take care
 
Back
Top