How to Create a Query to Specify Length in Access

With the Microsoft Office Access 2010 database manager software, you can create and run a query for the data in your database. You can also create criteria for a field and then run a query to return specific results. For example, you can use criteria in your query that satisfy length requirements. The query will look up all records that contain fields with names that are a specified number of characters.

• 1

  Click the "Start" button from the desktop and then click the "All Programs" option. Click the "Microsoft Access 2010" program from the list of applications.

• 2

  Select the "Microsoft Office" button from the top left corner of the application and then click the "Open" option.

• 3

  Locate and select the Access 2010 database file that you want to work with. Click the "Open" button.

• 4

  Right-click on the query table you want to specify length for and then click the "Design view" option.

• 5

  Enter "Len([Text]) > Number" into the "Criteria" row of your query field. Enter the field name text into the "Text" portion of the criteria and enter a length of characters for the text into the "Number" portion of the criteria.

• 6

  Select the "Run" button. Your query will then return the results that meet the criteria that you entered.