Return Text Length

[nida66]

I have data in a table where I would like a query to return all fields where the length of the text is above a certain value

e.g all records where there are more than 10 characters in the text field

Is there a nice simple way of doing this?

ta!

 

[traingamer]

where len([your field]) > 10

traingamer

 

[nida66]

sorry am new to access, is this entered into the Criteria field on the query design?

 

[traingamer]

Yes - in that case, just put:
Len([your field])>"10"
in the criteria

traingamer

 

[PHV]

[tt]Field Expr1: Len([field name])
Display unticked
Criteria >10[/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[nida66]

is working great, thanks guys!