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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Calculating arched beam surface area and volume on excel 3
retrieve last three characters of field 2
Query Records of Different Formats 1
Pipe character in query in VB6 app 11
How do I validate a field has 5 characters (alphanumeric)? 4
Query / Count Length Of Field 3
Normalizing semicolon delimited rows 2
SQL Strings Truncating at 255 Characters ? Why? 1

Back
Top