SQL statement- string to long error

I was given a template SQL statement that I was able to modify for Copier, Monitor and PC. I was able modify, save, and run these three statements without error.

When tried to create the Printer SQL statement, I would click OK to memorize this statement and I received an error " The return string for the builder was to long. The result will be truncated." Am I limited in the length of characters in the WHERE portion of these SQL statements? Is there anyway I can get around this? I will need to add more, NOT IN commands, to the WHERE portion of this statement in the future.

I have very little experience with SQL so please be gentle in your explaination.

Copier

INSERT INTO tblAllCT (CTNumber, location )

SELECT [copierct], [location]

FROM tblcopier1

WHERE copierct NOT IN (SELECT CTNumber FROM tblAllCT)

AND copierct NOT IN (SELECT pcct FROM tblpc1)

AND copierct NOT IN (SELECT monCT FROM tblMonitor1);



Monitor

INSERT INTO tblAllCT (CTNumber, location )

SELECT [monct], [location]

FROM tblmonitor1

WHERE monct NOT IN (SELECT CTNumber FROM tblAllCT)

AND monct NOT IN (SELECT pcct FROM tblpc1)

AND monct NOT IN (SELECT copierct FROM tblcopier1);



PC

INSERT INTO tblAllCT (CTNumber, location )

SELECT [pcct], [location]

FROM tblpc1

WHERE pcct NOT IN (SELECT CTNumber FROM tblAllCT)

AND pcct NOT IN (SELECT monct FROM tblmonitor1)

AND pcct NOT IN (SELECT copierct FROM tblcopier1);



Printer

INSERT INTO tblAllCT (CTNumber, location )

SELECT [printerct], [location]

FROM tblprinter1

WHERE printerct NOT IN (SELECT CTNumber FROM tblAllCT)

AND pritnerct NOT IN (SELECT monct FROM tblmonitor1)

AND printerct NOT IN (SELECT copierct FROM tblcopier1);

make sure the fields in red are the same data type and length in the database.

I found the answer.
It appears that there is a 256 charcter string limitation.
I trimmed down my code to mulitple strings and it works
fine.