Query to extract only parts of a content of a field

  • Thread starter Thread starter Faio
  • Start date Start date
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?
 
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
 
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting part of a field 2
extraction. 2
Extract numbers 9
if-then statements in a query 6
How to query value of several column fields from a lookup table 8
I need part of a memo field 4
Form question: Simplest way to bring in a query result that is notthe record source into a form? 3
"Read Only" Query 0

Back
Top