Access 2007 Will not accept wildcard

I have a query and in the criteria for a text field (Route), I'm placing
the following statement:

Like "*433"



When executed, the query will not return any rows. However, if I type
in each option (IE433, X433, etc.) and execute each one, results are
returned.

I had another query where I used this with no issue.
Any ideas as to what the problem may be?

Thanks,
Rita Brasher

It could be that you have checked use ANSI compliant SQL. If so the wild card
is a % sign. Try using
Like '%433'
and see if that works

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Rita Brasher wrote:
I have a query and in the criteria for a text field (Route), I'm placing
the following statement:

Like "*433"



When executed, the query will not return any rows. However, if I type
in each option (IE433, X433, etc.) and execute each one, results are
returned.

I had another query where I used this with no issue.
Any ideas as to what the problem may be?

Thanks,
Rita Brasher

Do you have any formating on the field?

Post the SQL of your query.

--
Build a little, test a little.


"Rita Brasher" wrote:

I have a query and in the criteria for a text field (Route), I'm placing
the following statement:

Like "*433"



When executed, the query will not return any rows. However, if I type
in each option (IE433, X433, etc.) and execute each one, results are
returned.

I had another query where I used this with no issue.
Any ideas as to what the problem may be?

Thanks,
Rita Brasher
.

Here's the SQL:

SELECT DISTINCT [Monthly Shortages].ARRIVAL_WORK_DT, [Monthly
Shortages].AIRBILL_NBR, [Monthly Shortages].TRACKING_NBR, [Monthly
Shortages].PORT_ID, [Monthly Shortages].ORIGIN_LOCATION_CD, [Monthly
Shortages].ROUTE_NBR, [Monthly Shortages].SERVICE_CD
FROM [Monthly Shortages]
WHERE ((([Monthly Shortages].ARRIVAL_WORK_DT)="20100510") AND (([Monthly
Shortages].ROUTE_NBR) Like "*433"));


All fields are text. (I didn't create the table, I just access it.)



On 5/6/2010 3:10 PM, KARL DEWEY wrote:
Do you have any formating on the field?

Post the SQL of your query.