Access 2010 Len Function in query grid
Posted on 2013-05-21
I utilize the Len function to count the number of characters in a datafield [H_SVP] which contains such data as A, BB, DDD, etc. I use Len([H_SVP]) in a database which normally returns 1, 2, 3 respectively.
For some reason I return no results when I use the exact same field and len function in a different database....I don't get an error message just blank cells when I run the query.
I tried creating a new database and importing everything in case I had a bug but that didn't work either.
Any idea on why the Len function wouldn't work?