Add or remove a field
A field is a category of information, such as a product name or order amount, that's stored in a table of information in a database. When you add or remove a field, your query includes or excludes the information from that field. The underlying database that supplies the information is not changed.
Add a field To add a single field to the result set, double-click the field you want to add in the Table pane.
Remove a field To remove a field from the result set, click the column heading of the field you want to delete in the Data pane, and then click Remove Column on the Records menu.
Tips
- To add several fields at one time from the same table, hold down CTRL while you click each field, and then drag the selected fields to the Data pane.
- To add all of the fields from a table to the result set, double-click the * (asterisk) at the top of the table in the Table pane.
