Hi Suzi,

Try:

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.)

or

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 $ ?clmlist

MartinJ

>Hi,
>I have a local view with syntax,
>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)
>
>where clmlist is variable.
>
>It seems that when I pass "001","007","008" as the clmlist variable, the local view only returns records that have clmoffice="001" (or whatever I pass in before the first comma).
>
>I also tried creating the view dynamically at run-time, but can't get the local view to refresh the data in a grid.
>
>Would be VERY GRATEFUL for any tips...
>THANKS!
>
>Suzi Taylor