Query to extract only parts of a content of a field

F

Faio

Hi,

Can anyone help on how to do this?

I have a field called CONTAINER# and wish to make a query to display all
records that start with TNLU???????

How to do that?
 
L

Luiz Cláudio C. V. Rocha [MVP]

Hi,

you can create a new query, select your table, drag CONTAINER field to the
grid and put the following Criteria:
LIKE "TNLU*"

Luiz Cláudio C. V. Rocha
São Paulo - Brazil
 
W

Wayne Morgan

Create a calculated field in the query.

Field - FilterMe:Left([FieldName], 4)
Criteria - "TNLU"

You can uncheck the Show box if you don't want this to show in the query's
output, the filter will work either way.
 
F

Faio

Thanks it both answers works

Wayne Morgan said:
Create a calculated field in the query.

Field - FilterMe:Left([FieldName], 4)
Criteria - "TNLU"

You can uncheck the Show box if you don't want this to show in the query's
output, the filter will work either way.

--
Wayne Morgan
MS Access MVP


Faio said:
Hi,

Can anyone help on how to do this?

I have a field called CONTAINER# and wish to make a query to display all
records that start with TNLU???????

How to do that?
Click to expand...
Click to expand...
 
Top