How to Count Field Characters in an Access Query

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'll Need

  • PC running Windows XP or later
  • Microsoft Access 2007 or later
Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Bennett Gavrish is an I.T. professional who has been writing about computers, electronics and the Web since 2004. His work has appeared in the "Nashua Telegraph" and the "Daily Free Press" and on numerous websites. Gavrish received a bachelor's degree in journalism from Boston University.