Formula/ expression for filtering out character length

[joolsUK0575]

Hi there

I have some information in a database that I need to make sure sure is correct.

There should be 11 characters (numbers, text and items such as /) within this particular field.

I know that there is a number of entries that either has more or less than the 11 characters in this particular field.

How do I create a query to look for and tell me all the entries that are less than 11 characters and all the entries that are more than 11 characters?

Thanks. Hope I explained clearly

Jools

 

[Eckerslike]

You can use

Length: Len([Nameofyourfield])

In a query and then do a >11 and <11 on this new field

 

[Bat17]

add a where clause to the SQL to check length

WHERE (((Len([YourFieldName]))<>11))

HTH

Peter

 

[joolsUK0575]

Thanks. Worked like a charm