|
Free Resources from FMS |
|
|
|
|
"Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities." - Darren D. |
|
|
|
|
Microsoft
Access Resource Center
Quickly Filtering Data in Any Datasheet View
Provided by: Steve Clark, Senior Project Manager
Whenever viewing data in any datasheet view (i.e. Table, Query, Datasheet Form or Subform), you can quickly filter the data that is displayed by applying a quick filter. You can apply more than one filter, and you can continue adding filters until you reach one or no more records.
One way to do this is to Right-click in any column (not on the column header) to perform a quick filter. When you right-click, a menu is displayed with the following options:
1. Filter By Selection
2. Filter Excluding Selection
3. Filter For [textbox to enter criteria]
The first two are very useful and self-explanatory, but the third is somewhat scary, as it allows input from the user. It has a textbox in the menu that accepts entry of any valid criteria, just as you would if you were creating a query. For starters, try entering an exact value from your data. (e.g. ALFKI, 12209, or Germany). To take this a step further, you can also use the 'OR' operator. (Germany OR Mexico). Finally, to really give you flexibilty, you can use the pattern matching(*[mdb] or %[ADP]) operators and/or the comparison(<,>,<>, Between...And) operators.
For example:
Germ* or Mex* - Return Germany or Mexico
(202)* - Return all phone numbers that start with area code (202)
>17 - Return all people over the age of 17
Between Date()-30 and Date() - Everything that occurred in the last 30 days.
So, although the filtering capability was designed to be a quick and dirty way to drill into your data, it still offers a very robust ability to get there. But, if you find that you are repeating the same filter on a regular basis, then you should probably save it as a query.
