Link to home
Start Free TrialLog in
Avatar of Mark Drelinger
Mark DrelingerFlag for United States of America

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="CASHCUC100" 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>
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mark Drelinger

ASKER

invalid syntax error.
LIKE "auth_id=["]["] auth_value=["]["]"
A variation worked - thanks - you got me in the right direction. Single quotes instead.
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)