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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Need to see everything in field except the last two characters 4
replace characters in table 6
A query for 12 month rolling values 0
Filter Records not Begginning with Numberic Characters 2
return record if 5th character is a letter 4
Numbers & text 8
Include first 3 characters in results 4

Back
Top