maximum/minimum Character

  • Thread starter Thread starter Jessie
  • Start date Start date
J

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
 
Hello.

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

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...
 
Back
Top