Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Pasting a string in MS Access I get and extra double quote

Posted on 2009-04-16
Medium Priority
Last Modified: 2012-08-14
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.
Question by:servent1
LVL 77

Accepted Solution

peter57r earned 500 total points
ID: 24165697
Are you saying that when you type the criteria these extra unprintable characters are just appearing - you are not typing them?
If that is so, then i would say there is a problem either with your Access installation or your pc.  Perhaps a simple reboot is the first step.
LVL 22

Assisted Solution

8080_Diver earned 500 total points
ID: 24727148
The problem is that the pasted data is being interpretted as a string without any consideration as to whether or not it has already wrapped things in quotes.  So, Access, in trying to be helpful, is wrapping the string that you pasted into the Criteria field in double quotes for you . . . which is actually being unhelpful. ;-)
You might try pasting the criteria piece-meal:
First past the LIKE "97005*" and then the LIKE "97006*"
However, I am trying to figure out what the problem is in just typing that into the Criteria field instead of cutting and pasting. :-/  If you are typing directly into the Criteria field, how are you getting "hidden characters"?

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question