重复记录查询帮助 [英] duplicate records Query help
问题描述
我有一个查询检查2个字段的重复记录。我遇到的问题是,遗憾的是数据区分大小写。所以M!= m但查询不区分大小写。有没有办法让我的查询区分大小写,以便我可以从查询中取消误报?
如果有帮助,这里是quey
I have a query that checks for duplicate records on 2 fields. the issue I am having is that the data unfortunately is case sensitive. So M != m but the query is case insensitive. Is there a way to make my query case sensitive so I can cancel out the False positives from the query?
here is the quey if that helps
推荐答案
我有一个查询重复记录的查询2个领域。我遇到的问题是,遗憾的是数据区分大小写。所以M!= m但查询不区分大小写。有没有办法让我的查询区分大小写,以便我可以从查询中取消误报?
如果有帮助,这里是quey
I have a query that checks for duplicate records on 2 fields. the issue I am having is that the data unfortunately is case sensitive. So M != m but the query is case insensitive. Is there a way to make my query case sensitive so I can cancel out the False positives from the query?
here is the quey if that helps
将字段更改为UCase([yourfield])
使所有内容大写
change the fields to UCase([yourfield])
makes everything upper case
实际上,他们想要与此相反,区分大小写比较。
使用StrComp(string1,string2,compare),其中compare = 0或vbBinaryCompare。如果它们完全匹配,它将返回0
Actually, they want the opposite of this, a case sensitive compare.
Use StrComp(string1, string2, compare) where compare = 0 or vbBinaryCompare. If they match completely it''ll return 0
将字段更改为UCase([yourfield])
>
使所有内容大写
change the fields to UCase([yourfield])
makes everything upper case
感谢您的回复,但我要做的是确保不捕获唯一的数据差异是价值的外壳。例如
record1
Field1 = 1234
Field2 = m
record2
Field1 = 1234
Field2 = M
Record3
Field1 = 1234
Field2 = m
我需要的是
Record1 = Record3
但是Record1<> Record2或Record2<> Record3
我希望这有帮助
CG
thank you for your response, but what I am trying to do is to make sure not to capture the data that the only difference is the casing of the values. for example
record1
Field1= 1234
Field2=m
record2
Field1=1234
Field2=M
Record3
Field1=1234
Field2=m
what I need is
Record1 = Record3
but Record1 <> Record2 or Record2<>Record3
I hope this helps
CG
这篇关于重复记录查询帮助的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!