Query

P

Pass-the-reality

I have a query that pulls data into three columns. The three columns are
SPDStatus, PMAStatus and SLStatus. If the data in all three columns are (in
any order) Complete, Complete-Deemed or Roll-up, I do not want that line to
show up. For example: I would not want rows 1 or 2 to show up.

SPDStatus PMA Status SLStatus
Complete Complete Complete
Complete-Deemed Roll-up Complete
Active Review Complete
 
K

Ken Sheridan

Try this:

SELECT SPDStatus, [PMA Status], SLStatus
FROM [YourTable]
WHERE NOT
(SPDStatus IN ("Complete","Complete-Deemed","Roll-up")
AND [PMA Status] IN ("Complete","Complete-Deemed","Roll-up")
AND SLStatus IN ("Complete","Complete-Deemed","Roll-up"));

Ken Sheridan
Stafford, England
 
Top