Number of Characters in Text > 12

  • Thread starter Thread starter Haji
  • Start date Start date
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
 
WHERE len([MyField])>12

or in the Query Builder put

len([MyField])>12

in the Criteria box under MyField
 
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...
 
Back
Top