Chapter 11: Locating Specific Information

Page 245	To filter a table by selection
	Open the table in Datasheet view. Click any instance of the selection by which you want to filter, and then click the Filter By Selection button.
245	To remove a filter
	Click the Remove Filter button.
245	To exclude a field from a filter process
	Right-click the field you want to exclude, and click Filter Excluding Selection on the shortcut menu.
247	To filter by form in a form
	Open the table or form you want to work with in either Datasheet or Form view. Click the Filter By Form button on the toolbar. Click the field or fields in which you want to create the filter, type the filter criteria you want, and press [ENTER]; or select the criteria from the list of options. (Repeat this step for any other fields you want to filter.) To add additional filter criteria for a particular field, click the Or tab and enter the criteria as necessary. Click the Apply Filter button.
250	To filter by multiple criteria
	Open the table in Datasheet view. On the Records menu, point to Filter , and then click Advanced Filter/Sort . If the design grid is not blank, on the Edit menu, click Clear Grid . Select the criteria by which to filter. On the Filter menu, click Apply Filter/Sort to view the records that match the criteria.
253	To create a select query in Design view
	On the Objects bar, click Queries . Double-click Create query in Design view . In the Show Tables dialog box, double-click each table that you want to includein the query, and then close the dialog box. To include a field in the query, drag it from the field list at the top of the windowto consecutive columns in the design grid. To copy all fields to the grid, double-click the title bar above the field list to select the entire list, and then drag the selection over the grid. Click the Run button to run the query and display the results in Datasheet view.
253	To add an expression to a query
	Open the query in Design view. Right-click the appropriate cell in the design grid, and then click Build on the shortcut menu. In the Expression Builder dialog box, double-click the Functions folder in the firstcolumn of the elements area, and then click Built-in Functions . Build your expression, and then click OK . Press [ENTER] to move the insertion point out of the field, which completes the entry of the expression. To rename the expression, double-click Expr1 , and then type the name you want. Click the Run button to run the query and see the results in Datasheet view.
264	To perform a calculation in a query
	Open the query in which you want to perform a calculation. Click in the field in which you want to perform the calculation, and then click the Totals button on the toolbar. In the new Totals cell for the field, click the down arrow, and then click the calculation you want to perform from the drop-down list.