- 1). Open Microsoft Access and go to the database you want to work with. Open the table containing the data you want to trim.
- 2). Write down the field names containing the data you want to trim. Close the database table, and then go to the "Query" section.
- 3). Choose to create a new query using the design view option. Select the table you want to base the query on, and then add the fields you want to see. Be sure to select the fields containing the data you want to trim.
- 4). Place your cursor to the right of the last field in the design view grid. Type "Trimmed: ([LTrimField])" in the Field box. For instance, if you want to trim the blank characters from the left of a field named Description, you would type "Trimmed: LTrim([Description])." If the Description field contained " Hex Key" the trimmed version would simply show "Hex Key."
- 5). Use the RTrim function in the same way. The RTrim function removes blank spaces to the right of the field, and it is used the same way as the LTrim function.
previous post