Columns <name> and <name> that you are about to join are of different types. Create the join anyway?

You're trying to join fields (columns) that contain different data types. For example, you may be trying to join a field that contains dates with a field that includes text.

• To prevent the join, click Cancel.
• To create the join, click OK.

Note  This type of join may not produce the results you want. Make sure Microsoft Query displays the data you want in the result set.