Type mismatch in JOIN expression

[Guest]

I have a couple of tables I am using to build an employe training database.
In my main database, when I try to sort records, I have two fields where I
get the following error messge..."Type mismatch in JOIN Expression". I
looked at the joined tables in design view and don't see a problem.
Can you help me out? I am not real proficient in Access, so please keep in
simple!
thanks for your help!!

 

[George Nicholson]

Look at the fields in each table that you are trying to JOIN to each other.
Are they the same Data Type? For example, trying to JOIN an EmployeeID Text
field to an EmployeeID Number field would cause a Type mismatch.

 

[Guest]

You probably have a statement in the SQL for the join that says something
like 'columnA = columnB' and the two columns are not of the same data type
e.g. one is a string and one is a number. To check the data types in design
view look in the 'Data Type' column. Examine the query by selecting VIEW--SQL
VIEW.

Dorian