Once again I need help. Our Tech support upgraded my access from 2000 to 2002. I think that is right. Now when I create a query from two difference tables I get an error saying "Type mix match expression" Does any one know what this means. I have two tables linked by ssn# One table has name, address, etc. Second table has only ssn, goals and activies fields. I enter the ssn and check if goals and activies is completed. Before when I ran a query using both table the result would show all clients who had completed goals. Can someone help with this problem. Please!

The linked fields are of different datatype or if strings, have difference number of characters.

Thank you. I have figured out the problem.