servent1
asked on
Pasting a string in MS Access I get and extra double quote
I'm doing a search query in MS Access such as:
Like "97005*" Or Like "97006*"
So I type the above and pasted it into notepad to remove any
hidden characters. When I paste it in my query in the criteria
field I get these fricking extra double quotes:
Like "" 97005*" " Or Like " "97006*" "
Also, if you know an easier way to set up a search like the above
please tell me. I have about 30 zipcodes I checking for.
I have to use the MS Access non-programming way using
the design tab view.
Like "97005*" Or Like "97006*"
So I type the above and pasted it into notepad to remove any
hidden characters. When I paste it in my query in the criteria
field I get these fricking extra double quotes:
Like "" 97005*" " Or Like " "97006*" "
Also, if you know an easier way to set up a search like the above
please tell me. I have about 30 zipcodes I checking for.
I have to use the MS Access non-programming way using
the design tab view.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.