Field is too small to accept the amount of data you attempted to add ERROR PROBLEM

[Ashley]

I have 2 queries I am trying to join using two Primary Keys


So when I do this join with one key i get improper result but when I
use both the keys to join I get this error "Field is too small to
accept the amount of data you attempted to add. Try inserting or
pasting less data.'


NONE OF MY FIELDS ARE MEMO fields.

What can be the problem. How do I fix this.

Please let me know if someone had the same problem. I googled the issue
but most answers were not helpful. I am not entering data.
Say, I am running a query Z based on 2 other queries say A and B. A is
based on C and D. B is based on E and F.

A and B both have two common fields which make a primary key together.
ItemID and OrderID.
So I need to join with both and not one to make it work properly.

 

[Joseph Meehan]

I have 2 queries I am trying to join using two Primary Keys


So when I do this join with one key i get improper result but when I
use both the keys to join I get this error "Field is too small to
accept the amount of data you attempted to add. Try inserting or
pasting less data.'

It appears you are combining two filed into one. If those two fields
together total more than 255 characters, that would explain the message.