Field Length Greater than...

[Seajay]

There's probably an easy answer to this, but if so, it has eluded me thus far.

I'm trying to run a qry in Access 97 where the length of a trimmed field is greater then 2 characters.

Any ideas?

 

[Dugantrain]

Well, your post is unclear on exactly what you're trying to do/what your problem is. Are you trying to get it down to one character? Are you getting some error message. Give more details.

 

[Mile-O]

You need to create a new field that tells you the length. We'll use the Len() function to return the length.

In a blank field in the query grid put this:

Length: Len([MyField])


Replace MyField with the name of the field you want to check the length of.

Set this new field's criteria to: >2



Or, for completeness:

Length: Len(Trim([Myfield]))

An NZ function in there, also, may not go amiss.

 

[Seajay]

Thanks

Thats exactly what I needed Mile-O-Phile...
Thx