Number of Characters in Text > 12

H

Haji

Hi,

I am trying to filter out some data that I have in a
query. I have determined that I don't want any value
from my table that has 12 or less characters in it. Is
it possible to create a query that takes this request
into account?

Thanks,

Chuck
 
R

Roger Carlson

WHERE len([MyField])>12

or in the Query Builder put

len([MyField])>12

in the Criteria box under MyField
 
J

John Spencer (MVP)

Or one other option using like operator

MyField Like "????????????*"

Roger said:
WHERE len([MyField])>12

or in the Query Builder put

len([MyField])>12

in the Criteria box under MyField
--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Haji said:
Hi,

I am trying to filter out some data that I have in a
query. I have determined that I don't want any value
from my table that has 12 or less characters in it. Is
it possible to create a query that takes this request
into account?

Thanks,

Chuck
Click to expand...
Click to expand...
 
Top