ms access - Search for text with specific length and no spaces -

i learning access (2010) , trying set criteria query brings names length 10 letters , there no spaces.

i tried len([name])="10" , returns names length of 10, includes names space in it.

the hint given was:

use wildcards * , ?, , phrases , not like"

however not enough me sort out.

what criteria solve this?

for else looking solve sort of issue, try this:

select communication.communicationcode, communication.communicationname communication len([communicationcode])=10 , communicationname not "* *" 

you need remove quotes 10.