Try

...
Where Not EXISTS (Select * From engpmtbl5a 
			Where badgeno = appusrprf1.badgeno
				AND tsstat = 1 And wend = whatWeek) 
...

>Each of the two parts of this SQL statement will complete in about 3 seconds. However, when I put them together it takes approox 60 seconds to run. Is there something to do that it would run faster?
>
>requiredListString = "Select appusrprf1.fname, appusrprf1.lname, appusrprf1.usrid1, appusrprf1.badgeno, appusrprf1.deptno, appusrprf1.emadd From appusrprf1 Where badgeno Not In (Select badgeno From engpmtbl5a Where tsstat = 1 And wend = '" + whatWeek + "') And times = 1 And activee = '" + PadR('Active',8) + "' Order By deptno, lname"