Mark Drelinger
asked on
access query to filter on quotation marks
I have a field in Access that contains the following text - I need to query if it DOES NOT CONTAIN auth_id="" auth_value=""
<ROOT><NEW_DATA FILE_NO="7539" BRANCH="01" CUST_ORD_NO="" TAX_NO="" TYPE="P" FREIGHT="0.00" SALESMAN="S108" ORD_DATE="2015-09-01 07:30:36.480000" CUSTOMER_NO="CASHCUC100" VEHICLE_NO="" SPECIAL_INST="FTB RECYCLING JOHN POLNY 4135 7210 0051 3763 EXP 06/19 1Z6516890135580054 DROP SHIP FROM DEERE" TRF_TO_BRANCH="" DEPOSIT="" RO_BRANCH="" RO_NUMBER="" NOTE="" auth_id="" auth_value="" REC_CONTROL="2015-09-01 07:30:37.132000" Tax_Region="MATAX" Tax_Status="ST" Cust_Delivery_Flag="N" Addressee_Contact_Code="CA SHCUC100" Pay_Method="Cash" Tax_Exempt_Type="" Foreign_Currency_Id="" Deposit_Foreign="" Run_No="" Run_Date="" Run_Direction="01" Created_By="S112" Created_On="2015-08-31 08:09:31.942000" change_del_addr_flag="Y" name="" surname="" company_name="JOHN POLNY " street="166 LINCOLN ST" city="MILLVILLE " pcode="01529" cust_pickup_flag="Y" state="MA"/></ROOT>
<ROOT><NEW_DATA FILE_NO="7539" BRANCH="01" CUST_ORD_NO="" TAX_NO="" TYPE="P" FREIGHT="0.00" SALESMAN="S108" ORD_DATE="2015-09-01 07:30:36.480000" CUSTOMER_NO="CASHCUC100" VEHICLE_NO="" SPECIAL_INST="FTB RECYCLING JOHN POLNY 4135 7210 0051 3763 EXP 06/19 1Z6516890135580054 DROP SHIP FROM DEERE" TRF_TO_BRANCH="" DEPOSIT="" RO_BRANCH="" RO_NUMBER="" NOTE="" auth_id="" auth_value="" REC_CONTROL="2015-09-01 07:30:37.132000" Tax_Region="MATAX" Tax_Status="ST" Cust_Delivery_Flag="N" Addressee_Contact_Code="CA
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
A variation worked - thanks - you got me in the right direction. Single quotes instead.
Not Like '*auth_id=""*'
Not Like '*auth_id=""*'
where was my comment.... ????
try this
where [fieldname] not Like "auth_id=" & Chr(34) & Chr(34) & " auth_value=" & Chr(34) & Chr(34)
try this
where [fieldname] not Like "auth_id=" & Chr(34) & Chr(34) & " auth_value=" & Chr(34) & Chr(34)
ASKER
LIKE "auth_id=["]["] auth_value=["]["]"