In Operator Example

The following example uses the Orders table in the Northwind.mdb database to create a query that includes all orders shipped to Lancashire and Essex and the dates shipped. The  example calls the EnumFields procedure, which you can find in the SELECT statement example.

SELECT CustomerID, ShippedDate FROM Orders 
WHERE ShipRegion In ('Lancashire','Essex');