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 |
| |
245 | To exclude a field from a filter process |
| |
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. |