MS Access Query: IN List sytax 1

[des0929]

Does anyone know the MS Access query sytax for an in list condition

FoxPro example:
Select * from table where inlist('Tom','Mary')

Thanks.

 

[mpastore]

For foxpro I think you meant..

Select * from table where inlist(mfield,'Tom','Mary')

MS Access equavalent is ...

Select * from table where mfield in('Tom','Mary')





Mike Pastore

Hats off to (Roy) Harper