Hello, this may seem a really stupid question and I use excel regularly but i can't figure this out. I got to getting the query setup, but i can't figure out how to use criteria len(cell?) <= 2.
Novice
Windows 7 64bit 
Access 2010 64bit
Hello, this may seem a really stupid question and I use excel regularly but i can't figure this out. I got to getting the query setup, but i can't figure out how to use criteria len(cell?) <= 2.
Who is John Galt?
Windows XP Access 2007
You'd use the field name:
len(FieldName)
Novice
Windows 7 64bit Access 2010 64bit
When I do len("field") <"3" i get zero results, when I do len([field]) <"3" I get the first words filtered correctly, and then cell 4 till end is not filtered correctly. really frustrating!
Who is John Galt?
Windows XP Access 2007
You don't want quotes in either place. In SQL view it would look like:
WHERE Len([field]) <3
Novice
Windows 7 64bit Access 2010 64bit
Is there some kind of setup that doesn't allow for ANY fomulas. Like if I enter a formula in a cell, it never calculates - this is driving me nutz.
Who is John Galt?
Windows XP Access 2007
You mentioned a query earlier. What exactly are you trying to do, and where is this formula?
Checking for trailing letter
Posting Permissions
Reply With Quote