Jim,

There's no JOIN condition between appfile and userfile tables in your select.

>Any ideas why the second SQL statement here works fine in development, but fails on error 1814 in my EXE?
>

SELECT STR(PROCESSID,6,0)+STR(usernumber,6,0) FROM accessfile INTO CURSOR Temp
>
>SELECT appfile.PROCESSID, userfile.usernumber 		;
>	FROM appfile,userfile 				;
>	WHERE NOT STR(PROCESSID,6,0)+STR(usernumber,6,0) IN 	;
>	(SELECT * FROM Temp) 				;
>	INTO CURSOR NewRecs READWRITE
>

>(I'm trying to find all combinations of ProcessID and UserNumber, both N(6), not already found in AccessFile.)
>
>Any suggested alternatives?
>
>Thanks