Query

[momoko]

Hi,
I have a text field, how can I use query to filter out those have more than 7 character.

Thks,

 

[Newman]

Create a field in the query and name it
NbCar([textbox])
and give it the condition
>7
Newman

 

[The_Doc_Man]

Not familiar with NbCar but if you use Len(Trim([myfield])) as one of your query fields, then select <7 in the criteria row, that should do it.

 

[Newman]

Sorry, my mistake.
NbCar is the french version for Len. It's hard to work with both versions at the same time.
Newman
By the way, adding TRIM is a good idea, never done this but I should have!

 

[The_Doc_Man]

To be honest, I left out something too...

Should REALLY be

Len( Trim( Nz( [myfield], "" ) ) ) and criteria <7

Unless you want zero-length to be ignored.