A
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.
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.