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.
Other People Are Reading
Instructions
-
-
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.
-
1
Tips & Warnings
Once you delete the text from the field, then save and close the query, you cannot retrieve that text again. Double-check to ensure that you definitely want to remove that text before saving.
