<div>
...thank you, when I unchecked and then rechecked the references it worked.
</div>


...thank you, when I unchecked and then rechecked the references it worked.

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
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. &nbsp;I use Len([H_SVP]) in a database which normally returns 1, 2, 3 respectively.<br />
<br />
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. <br />
<br />
I tried creating a new database and importing everything in case I had a bug but that didn't work either.<br />
<br />
Any idea on why the Len function wouldn't work?
</div>
</div>


Hi Experts,

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?

Access 2010 Len Function in query grid

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.