SELECT DISTINCT b.[Employee ID], b.Project, b.Product, b.[Project Salary], b.Report
FROM tbl_CHGLI030b AS b
WHERE b.Report<>"exclude";
Pretty straight forward right?
when I make it ="exclude" it returns all those where the Report field contains exclude, when I leave it as it is above, it returns nothing - and there are plenty that do not contain exclude.
Where NOT b.Report="exclude" is not working either... it is returning nothing, why is this?
FROM tbl_CHGLI030b AS b
WHERE b.Report<>"exclude";
Pretty straight forward right?
when I make it ="exclude" it returns all those where the Report field contains exclude, when I leave it as it is above, it returns nothing - and there are plenty that do not contain exclude.
Where NOT b.Report="exclude" is not working either... it is returning nothing, why is this?