Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Gary Costigan
Yak Posting Veteran
95 Posts |
 Posted - 2003-10-16 : 14:31:09
|
| Just wanted to run this by the group.Can Access perform a function where it will delete duplicates of something and leave only the latest input or transaction?We have a table where we get duplicate call records on a customer. The customer ID and all other info stays the same and there is one area that is updated with each contact. For customer "A" there might be 5 records of our contacts with them. Is it possible to sort the records and then delete the last 4 so that we only have the latest contact with the customer when we want to clean up the table?Suggestions, comments, answers!!Thanks again.GC |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-16 : 14:34:54
|
| Isn't this a duplicate thread?[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=29882[/url]Tara |
 |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2003-10-16 : 16:40:55
|
Yes it is with a duplicate answer.Can we run the Script yet? |
|
|
|
jhermiz
3564 Posts |
Posted - 2003-10-25 : 23:05:08
|
| Just write a delete query.DELETE FROM blah WHERE ....Jon |
|
|
|
|
|
|
Delete Logic Question