Microsoft Office 2003 All-in-One

If you place a field that you don't want into a field column, you can replace it using the drop-down list in the Field box (of that column) to select a different field. If you don't want a field in that field column at all, you can delete the field from the query. Deleting the field deletes the entire field column from the query. You can use two methods for deleting a field column from the query:

• Click anywhere in the column and select Edit, Delete Columns.

• Position the mouse pointer directly above the column so that the pointer turns into a downward-pointing black arrow. Then click to select the entire column. To delete the selected field column, press Delete.

After you have selected the fields that you will use in the table, you are ready to set the criteria for the query.