Consistent number of characters

[Guest]

I have a table and one of the fields should consistently be 10 characters in
length. Although we have mentioned to temporary data entry staff to enter 10
characters, for some reason it was not always followed. How do I find
(1000's) records with less than 10 characters in this field? Any help is
appreciated.

Thank you.

 

[Guest]

Hi,
run a simple select query on it. Create a new expression in the query which
count the length of the characters in your field e.g.:
NewField: Len([YourField])

Then set criteria on this expression to filter out everything which is < 10
HTH
Good luck

 

[Guest]

Expr1: Len([YourField])

Use criteria --- <10

 

[fredg]

I have a table and one of the fields should consistently be 10 characters in
length. Although we have mentioned to temporary data entry staff to enter 10
characters, for some reason it was not always followed. How do I find
(1000's) records with less than 10 characters in this field? Any help is
appreciated.

Thank you.

Create a new Query.

Select TableName.[FieldName], IIf(Len([FieldName]) =
9,"OK",Len([FieldName])) as HasNine From TableName;

 

[Chriske911]

I have a table and one of the fields should consistently be 10

characters in length. Although we have mentioned to temporary data
entry staff to enter 10 characters, for some reason it was not
always followed. How do I find (1000's) records with less than 10
characters in this field? Any help is appreciated.

Thank you.

do not ask this (not even very nicely)
implement it, make it required before saving the record
you can do this with an input mask
or with vba code

grtz

 

[Guest]

Thank you everyone for your input. I will use the LEN function to find the
records with less than 10 characters and implement an input mask for future
data entries.

I really appreciate everyone's help. Thank you.