Criteria in Query

  • Thread starter Thread starter Mike
  • Start date Start date
M

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")
 
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.
 
Back
Top