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.

Example of a single field selected 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.