Count Number of Characters

K

Kevin C.

I have a field in a database Called Agency. The Agency
number is either 8 character or 9 characters long. I
want to do different thing with the agency number but
they are dependant on the size of the Agency number. Is
there a function that can count the length of the data
entered in the Agency number field?
 
V

Van T. Dinh

Len([AgencyCode]) should return the length.

Check Access VB Help on the Len() function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

wish there was a CountDistinct() function 6
Unique values in a query 2
How to count the numbers in a Word document? 0
select only one checkbox 2
Paragraph numbering in Word 1
Lookup a value in a table and display text if a value exists 1
Year to date values 2
Page numbering with Merged Document and IF statements 1

Top