Queries that involve relationships

VWilson39

Registered User.
Local time
Today, 20:22
Joined
Mar 21, 2002
Messages
18
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.
 

Users who are viewing this thread

Back
Top Bottom