[ms office - 2010] Access Query

[MatthewL]

I have a query in Access and I have 1 column which I need to filter if it has less than x characters in that column. Is there a way to do it?

 

I did try =Len([column]) <="x" but that didn't work.

 

Any suggestions?

[TLARWise]

Add a new column to the query with =Len([column]) as the field and then filter that column using <=x as the criteria.

[MatthewL]

Thanks, if I wanted to do more than x character presume just replace with >? I did try but it doesn't seem to work for greater than.

[TLARWise]

using >x should work, alternatively you can use >= but increase the character count by one (ie: if you want greater than 8 you can use >=9).

[MatthewL]

Thanks, will take a look.

 

Just done some manual checks re <="x" and it doesn't include them all, anything else I should be aware of?

[TLARWise]

When using numbers in a criteria you don't need to use quotes. When testing this didn't seem to make a difference for me but we use Office 2016 so 2010 may be more picky.

[MatthewL]

It ended up been >x no = sign.