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

Posted on 2009-04-16
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

    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

    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

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
    Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    This video discusses moving either the default database or any database to a new volume.

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now