The situation is I have an error message that mentions a mismatch in the from statement. What is a mismatch in the From statement? Can any one explain the different situations that would generate this type of error message? For a little background as to how the data was gathered. If I trace my action, I receive an excel spreadsheet. I needed to “text to column” or subdivide one column. Then add in a column to be able to generate a new number for multiple columns by concatenate. I then took the concatenated column and copied and pasted it into an access spreadsheet. Then when I used the Access dB as a part of my query I received the error.
I’d say the JOINs are part of the FROM clause, so if you are joining on columns with different data types, it could cause a type ‘mismatch’ error.
Also, have you tried this ? :
<pre>FROM [Red and Black] RIGHT JOIN <b>[</b>72IN0140wOE<b>]</b> ON [Red and Black].Field1 = [72IN0140wOE].PN;