maximum/minimum Character

[Jessie]

Hello.

How can I write a query that will show me the records that
have a character length <> 6?

Any help would be great.

Thanks,
Jessie

 

[John Vinson]

Hello.

How can I write a query that will show me the records that
have a character length <> 6?

A "record" doesn't have a character length; a field in a record would.

Create a Query based on your table. In a vacant Field cell type

FieldSize: Len([fieldname])

using the name of the field that you're checking. This will contain an
integer listing the size of the field in characters. Your

<> 6

criterion will give you what you want...