Solved

Querying for *

Posted on 2014-02-05
4
135 Views
Last Modified: 2014-02-07
I am trying to query for the * symbol within records and am having trouble with the usual way I would do this since the * is part of like "*(some value)*" that I would usually use. Any ideas?  Thanks!
0
Comment
Question by:daisypetals313
  • 2
  • 2
4 Comments
 
LVL 35

Expert Comment

by:mvidas
ID: 39836592
You should be able to query for [*] to find the literal asterisk instead of the wildcard.
Matt
0
 

Author Comment

by:daisypetals313
ID: 39836638
The * is mixed in with other characters so I need the like part
0
 
LVL 35

Accepted Solution

by:
mvidas earned 500 total points
ID: 39836653
What about using     *[*]*     in the Like. In the past I've written it as "*" & "[*]" & "*" to make it easier to understand later, but either should be good for what you need.
0
 

Author Closing Comment

by:daisypetals313
ID: 39841482
Thanks! I used *[*]* and it worked perfect.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

832 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