I was given a template SQL statement that I was able to modify for Copier, Monitor and PC. I was able to run these three without error.
When I went to memorize the Printer SQL statement I would receive 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 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);

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); [/SIZE][/QUOTE]

The error you are getting is actually produced when you have mismatched variables. You need to make sure that the fields you are inserting into have the same size as the fields you are inserting from. And if you are doing this insert with variables, you need to make sure your application has the same size as well.

I found the answer. I appears that there is a string limit of 256 characters, at lest in Access97. I broke down my statements to a smaller size and everything saved and ran fine.