添加addtional片到复制卸妆。 [英] Add addtional piece to duplicate remover.

问题描述

美好的一天！


首先，我要感谢Danny Lesandrini向世界发布了一个非常不错的重复删除方法。在那个说明。使用这种方法我想添加一个条件：


如果两个记录是重复的...但是注释在记录1中填充了字段（9），但在记录2中为空。我希望将记录2与记录1删除。

Good Day!

First I want to Thank Danny Lesandrini for publishing to the world a really decent duplicate removal method. On that note. Using this method I would like to add a condition:

If two records are duplicates ... but the "Notes" field (9) is populated in Record 1 but empty in Record 2 I would like to have Record 2 removed versus record 1.

展开 | < span class =codeLinkonclick =selectAll（this）;>选择 | 换行 | 行号

推荐答案

尝试以下代码。


这取决于找到重复项时将始终删除一条记录的事实。当第一个记录的Null为Field（9）时，总是（并且仅）设置书签。

Try the following code.

This relies on the fact that one record will always be deleted when a duplicate is found. A bookmark is always (and only) set when the first record has a Null as Field(9).

展开 | 选择 | Wrap | 行号

我运行了删除所有重复项的代码。

When I ran the code it deleted all the duplicates leving nothing.

你好，Mitch。


您可能希望阅读类似的帖子 - 删除类似记录。


问候，

Fish。

Hello, Mitch.

You may wish to read a similar thread - Delete Similar Records.

Regards,
Fish.

这篇关于添加addtional片到复制卸妆。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！