String data, right truncation (#0) - Strange

  • Thread starter Thread starter martin1b
  • Start date Start date
M

martin1b

Hey all,
I have a make table query that ties a local table to a linked table.
Whenever I try to run the query, I get the error above.

After troubleshooting, I find that 1 column is causing the problem-
it's a text field in the local table. So, I do a mid for 10 characters
from the 1st character and trim the whole thing. I still get the
errror.

This is really wierd. Any ideas?

TIA

Bill
 
I have a make table query that ties a local table to a linked table.
You did not say how you are "linking" the two tables. Do they have a common
field you are using in a join?
Whenever I try to run the query, I get the error above.
Click to expand...
What error is that?
 
Back
Top