Solved

How to use wildcard in query criteria

Posted on 2013-06-13
3
661 Views
Last Modified: 2013-06-13
See embedded picture please.
I have a form with controls "display" and "block" with parameter values and a query which uses these parameters in criteria.
The default values of two of the criteria field are * per default.
However the query renders no records under these conditions.
If I put * in the criteria of the query directly, it displays all records, but not when the criteria refers to the appropriate controls on the form.
If I select actual values in the controls, the query renders correctly.
What am I doing wrong. I believe I have done this before.
Picture of form and query
0
Comment
Question by:Fritz Paul
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39244992
try placing  "Like" in front of your criteria. i.e.,

Like Forms!NameOfform!NameOfControl

or

Like Forms!NameOfform!NameOfControl & "*"
0
 
LVL 57
ID: 39245003
In the query, you need to use the Like operator along with the control value or add a column in the query of using the control reference and put an asterick (*) as the criteria.

 So it's either some column = the form control or the form control = "*"

Jim.
0
 

Author Closing Comment

by:Fritz Paul
ID: 39245023
The "Like Forms!NameOfform!NameOfControl" works fine.
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

685 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