Hello,

clmlist=["001","007","008"]
SELECT Suspense.policyno, Suspense.claim, Suspense.drftamt,;
  Suspense.dduedate, Suspense.claimname, Suspense.dol, Suspense.ssn,;
  Suspense.adjustor, Suspense.clmoffice, Suspense.ntlogin,;
  Suspense.controlnum, Suspense.susp_code, Suspense.den_code,;
  Suspense.accepted, Suspense.denied;
 FROM suspense;
 WHERE Suspense.clmoffice IN (?&clmlist.)

should work

(make sure that you're variable clmlist is not initialzed when you create the view)

Regards

Christian