False results using <>

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

Guest

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?
 
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]
 
Kingston

Thanks this field truncation worked perfectly. I also changed the character
length to 1 for the field that was not matching and for whatever reason that
seemed to do the trick.

Sorry since i am a novice I did not know what the SQL is that you were
reffering to, But I seem to be set now. Thanks again
--
Thanks
ETC


kingston via AccessMonster.com said:
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]
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?
Click to expand...
Click to expand...
 
Back
Top