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")
Thanks
SELECT StoreNumber, TransactionNumber, TransactionDate, LineNumber
FROM MyTable
WHERE StoreNumber NOT IN
(SELECT DISTINCT StoreNumber
FROM MyTable
WHERE LineNumber = "MRD")