Re: False results using <>
- From: "kingston via AccessMonster.com" <u27511@uwe>
- Date: Mon, 27 Nov 2006 14:12:01 GMT
1. Is your query based on these fields only? In other words are other
criteria returning the records you don't want? Please post your query in SQL.
2. You can base the comparison on a truncation of the first field: Left(
[Field1],14) <> [Field2]
Sweetetc wrote:
I am comparing two large tables (3600 records) using <>. I have two issues.
1. One of the sets of column I can see visually match. ALL records in each
column have "N" yet the results are showing all records as not being equal.
I have checked the format which is text and the field size which is 255. Why
would this be showing false results? How can I get it to stop.
2. Another set of columns I am comparing is name. Where I pulled the data
from had different field lengths. So one column is John Smith School and the
field I am comparing truncated John Smith Sch How can I get these two columns
to appear to match?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200611/1
.
- Prev by Date: Re: comparing adjacent records - looking for dup/missing customer orders
- Next by Date: Re: Problem is sum hours, because when cross 24h start in zero
- Previous by thread: Re: ???Takes very long to do make table query
- Next by thread: Re: Removing extra spacing in imported text
- Index(es):
Relevant Pages
|
|
