Unmatched Records

[Topher]

Hey, for whatever reason the find unmatched wizard will not work for me when trying to setup a query. i have two tables - one table gets updated all the time so i have to use another table with all the part#s in it. when the 1st table gets updated i want to search for part#s which are not in the 2nd table yet - and then add them. for whatever reason every time i make the query which should work - it doesnt! both fields are the same name and are both text field. i tried trimming both tables but that didnt work either - i have also tried running the query with results to be shown from both tables not just the 1st one.

the only way i can get it to work is to write a little vba function which takes FOREVER to run - b/c i have to go thru 20000 records!

any one have any ideas? help much appreciated.

Topher

[This message has been edited by Topher (edited 01-10-2002).]

 

[boblarson]

This may not be your problem, however, I have found this problem in the past.

Even if both fields you're comparing are text fields, they have to have the same length specified in the table properties.

For example one may be 50 characters and the other may say 255 characters. An unmatched query doesn't seem to like that.

Same with other properties of the same field. Make sure they match EXACTLY.

BL
hth

 

[Topher]

Hey, thanks for the info. I checked and all fields are exactly the same. yet it still won't work.

I'll try playing around with it some more to see if i can get the fields separated at all??
-----
I created two tables separatly and just put in some junk text info. ran an unmatched query and it worked! i then wanted to load the tables with the part # information, and when i went to append i got the message that there were no records in the table which has the part #s - yet there IS information?? something is really messed up i think with these tables or db...?
-----
DOH - my fault - never checked one of the tables for any data in it - looks like something got screwy when i copied the DB and it didnt copy that table. now that theres data in it it works.

Thanks,
T

[This message has been edited by Topher (edited 01-11-2002).]

[This message has been edited by Topher (edited 01-11-2002).]