|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 27th, 2006, 01:09 PM
posted to microsoft.public.access.queries
|
|||
|
|||
False results using
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? -- Thanks ETC 
|
|
#2
November 27th, 2006, 02:12 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
False results using
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/For...eries/200611/1
|
|
#3
November 27th, 2006, 04:29 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
False results using
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" wrote: 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/For...eries/200611/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
