Criteria in Query

[Mike]

Where exactly is this formula put in ? Im a little confused.

Thanks



SELECT StoreNumber, TransactionNumber, TransactionDate, LineNumber
FROM MyTable
WHERE StoreNumber NOT IN
(SELECT DISTINCT StoreNumber
FROM MyTable
WHERE LineNumber = "MRD")

 

[Jerry Whittle]

Create a new query. When the Show Table dialog box appears, just close it.
Next go to View, SQL View and paste the SQL statement in there. Save the
query with an appropriate name then run it.