Type mismatch in JOIN expression. (Error 3615)

[trenny]

I am a novice, so any help is appreciated. I have imported 2 tables from Excel into a database. I am trying to run a query from both tables. I get the following error " Type mismatch in JOIN expression ". The help button says that my data may be of incompatible data types.
Any help?

 

[gnt]

trenny-
Be sure that the fields you're joining on are of the same data type, otherwise you can't relate them. Can you copy and paste your SQL into your post???
-gnt

 

[trenny]

Thanks. Even though the data came from the same place, it imported differently. I went into design view for each table and changed the data types to match each other.