Null Problem

[marcoman44]

In a query I am trying to excldue the string "02710000" The problem is that it also excludes all nulls. I am using <> "02710000". Any help is greatly appreciated.

Thanks


Code:

SELECT repFinancialInsured1.RxNo, repFinancialInsured1.DxDate, repFinancialInsured1.NDC, repFinancialInsured1.DrugName, 0.2 AS Rate, repFinancialInsured1.[Adjudication Approved], repFinancialInsured1.[Member Paid], repFinancialInsured1.[Total Reimbursement], [Rate]*[Total Reimbursement] AS [CCN Fee], repFinancialInsured1.TPGroup
FROM repFinancialInsured1
WHERE (((repFinancialInsured1.TPGroup)<>"02710000"));

 

[petermeachem]

AND repFinancialInsured1.TPGroup IS NOT NULL on the end

 

[PHV]

You may try either this:
WHERE Nz(repFinancialInsured1.TPGroup,"")<>"02710000";
or this:
WHERE (repFinancialInsured1.TPGroup<>"02710000" OR repFinancialInsured1.TPGroup IS NULL);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886