marcoman44
IS-IT--Management
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"));
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"));