Query Not Returning All Data 1

[carpetbelly]

Just using the standard query builder in access the SQL I get is the following

SELECT tblData.OriginatorName, tblData.DateIncidentRaised, tblData.IssueTitle, tblData.System, tblData.IncidentStatus
FROM tblData
WHERE (((tblData.IncidentStatus)<>"Closed"));

Now this just doesn't return any data I have in the table tblData.

if I remove the where clause then it returns all the data as you'd expect. Obv it's the where clause that's going wrong but my SQL is rather rusty lately. Anyone able to give some advice?

 

[PHV]

Does IncidentStatus hold only two values: "Closed" or Null ?
You may try the following SQL code:
SELECT tblData.OriginatorName, tblData.DateIncidentRaised, tblData.IssueTitle, tblData.System, tblData.IncidentStatus
FROM tblData
WHERE Nz(tblData.IncidentStatus,"")<>"Closed";

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[randy700]

How about...

WHERE tblData.IncidentStatus) Not Like "*Closed*"

Randy

 

[carpetbelly]

Thankyou both for the ideas... Much appreciated. The joys of being rusty with my SQL is embaressing =)