How to Remove Text From the Field in an Access Query

An Access query is a cross reference of information from the tables within your database. For example, you can run a "Find Unmatched Query Wizard" in Access to compare two tables and report all records from one table that don't match the other. If there's a field in your query containing data you don't need, you can remove the text with a few simple steps.

• 1

  Select the "Queries" object under the "All Access Objects" option arrow on the left-hand side of the screen. Double-click the name of the query that contains the information you want to modify. The query loads in your main Access window.

• 2

  Click inside of the box within the query table containing the text that you want to delete. Click and drag your mouse across the text to select the information.

• 3

  Click "Delete" or "Backspace" on your keyboard to remove the text from the field. Repeat this process for all text that you want to remove from the query.