Microsoft Office Tutorials and References
In Depth Information
Figure 7-2
Filter options for a Text field in Report view
click this area to close
the menu and submenu
shortcut menu filter options
Text Filters submenu filter options
The filter options that appear on the shortcut menu depend on the selected field’s
data type and the selected value. Because you clicked the ContractType field value
without selecting a portion of the value, the shortcut menu displays filter
options—various conditions using the value “Residential landscape plan”—for the
entire ContractType field value. You’ll close the menus and select a portion of the
ContractNum field value to show Sarah a different way of filtering the report.
4. Click an unused portion of the window (see Figure 7-2) to close the menus, and in
the report detail line for Contract Num 3011, double-click Residential in the
Contract Type column to select it, right-click Residential , and then point to Text
Filters on the shortcut menu. The filter options now apply to the selected text.
Notice that the filter options on the shortcut menu include options such as “Begins
With” and “Does Not Begin With,” because the text you selected is at the begin-
ning of the field value in the Contract Type column.
5. Click Contains “Residential” on the shortcut menu. The report content changes
to display only those contracts that contain the word “residential” in the Contract
Type column.
6. Double-click the word residential in the Contract Type column for the report
detail line for Contract Num 3015 to select it, right-click residential to open the
shortcut menu, and then point to Text Filters . The filter options on the shortcut
menu now include the “Ends With” and “Does Not End With” options, because the
text you selected is at the end of the field value in the Contract Type column.
Sarah wants to view only those contracts whose Contract Type column equals
“residential landscape plan.”
7. Click an unused portion of the window to close the menus, and in the report detail
line for Contract Num 3011, right-click Residential landscape plan in the Con-
tract Type column, and then click Equals “Residential landscape plan” on the
shortcut menu. Only the five contracts that contain the selected phrase are dis-
played in the report. See Figure 7-3.
 
Search JabSto ::




Custom Search