I currently have a SQL command:<BR><BR>INSERT INTO tblOption1 ( PersonMatched, PersonMatchedTo, tGrade, Score )<BR>SELECT TOP 15 RIGHT([FormID],5), [tFirstName]+&#039; &#039;+[tLastName], [tGrade], [Score]<BR>FROM tblProcessed<BR>WHERE FormID IN <BR>(SELECT RIGHT([FormID], 5) <BR> FROM tblSurvey <BR> WHERE [FormID] IS NOT NULL)<BR>ORDER BY [Score] DESC;<BR><BR><BR>Is there a way to do this without the nested SELECT statement in the WHERE clause? The FormID in tblProcessed contains mutliples of each FormID. I&#039;m using Access 2000 on Windows 2000.<BR><BR>Thanks for any help!<BR>