Pasting a string in MS Access I get and extra double quote
Posted on 2009-04-16
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.