Simple Query

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

How do I go about counting the characters in a query. eg.
I want to identify a list of data with precisely 10
characters in the column. Is there a simple way to do
this?

Thanks for your help.
 
To create a calculated field where only the first 10 characters of another
field are displayed, use the following expression in the Field: column:

Left([MyField], 10)

If this is not what you want, please post back to this thread.

hth,
 
A couple of ways. One use the Len function.

Field: TenChar: Len(YourField)
Criteria: 10

Another alternative:

Field: YourField
Criteria: LIKE "??????????"

Cheryl said:
To create a calculated field where only the first 10 characters of another
field are displayed, use the following expression in the Field: column:

Left([MyField], 10)

If this is not what you want, please post back to this thread.

hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

Heather said:
How do I go about counting the characters in a query. eg.
I want to identify a list of data with precisely 10
characters in the column. Is there a simple way to do
this?

Thanks for your help.
Click to expand...
Click to expand...
 
Back
Top