Returning records with fewer than 10 digits

[Paul]

I need to add a criteria to my query that will look at the field (which
should have 10 digits in it) and return all records with fewer than 10 digits
in the field.

Anybody know a way?

Thanks!

 

[KARL DEWEY]

In design view of your query pull down the field a second time an edit it
like this --
Number of Characters: Len([YourField])

Enter < 10 as criteria.

 

[Paul]

That worked awesome, thank you!

In design view of your query pull down the field a second time an edit it
like this --
Number of Characters: Len([YourField])

Enter < 10 as criteria.

I need to add a criteria to my query that will look at the field (which
should have 10 digits in it) and return all records with fewer than 10 digits
in the field.

Anybody know a way?

Thanks!

 

[John Spencer]

An alternative to Karl Dewey's response.

If your field is a text field and could have other characters in it (other
than numeric characters) or could be null you might want to use

Field: SomeField
Criteria: NOT Like "##########" OR Is Null

The original method would not find
" 1234567" Since that is ten characters in length (3 spaces followed by 7
characters)
"123456789A" 10 characters, but not all numbers

That worked awesome, thank you!

In design view of your query pull down the field a second time an edit it
like this --
Number of Characters: Len([YourField])

Enter < 10 as criteria.

I need to add a criteria to my query that will look at the field (which
should have 10 digits in it) and return all records with fewer than 10
digits
in the field.

Anybody know a way?

Thanks!