How to Count Field Characters in an Access Query

Written by bennett gavrish | 13/05/2017
How to Count Field Characters in an Access Query
You can use expressions in Access queries to manipulate your database's fields. (typing image by Dariusz Urbanczyk from

The Microsoft Office suite of professional desktop applications comes with a database tool called Access, which allows you to design relational databases and execute queries for finding information and creating reports. When building a query in Microsoft Access, you can use expressions to perform calculations with your data. The "Len" expression will count the number of characters in a specific field of your Access database file.

Launch the Microsoft Access program on your computer and open the database file where you want to create a new query.

Go to the "Create" tab in the toolbar and click on the "Query Design" button.

Double-click on the name of the table that stores the field you want to use and then press the "Close" button in the pop-up window.

Place your cursor in the leftmost column of the grid in the lower half of the window.

Open the "Field" drop-down menu and select the name of the field of which you want to count characters.

Go to the "Criteria" section, type "Len([Name])" and replace "Name" with the exact name of the field you want to count.

Press the "Run" button at the top of the screen. Access will now run a report that counts the number of characters in the field you chose.

Things you need

  • PC running Windows XP or later
  • Microsoft Access 2007 or later

Show MoreHide

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.