Faculty/Staff Help Student Help About Computer Services    
   

Access Tip -  Filtering by selection

When examining data, you'll often want to view all of the records that have a particular field value. For example, you might see a questionable grade as you scan a datasheet and want to examine all of the records pertaining to the student in question. First, place your insertion point in the field containing the data that should be found in all of the records you want to see--such as a Student ID field. Then, select Records > Filter > Filter By Selection from the menu bar or click the Filter By Selection button  on the toolbar. To redisplay all records, choose Records > Remove Filter/Sort from the menu bar or click the Remove Filter button  on the toolbar. You can filter by selection with both datasheets and forms.

.

 

 

 
Ouachita Baptist University • Computer Services
Cone Bottoms Hall 250 • 870.245.5567

online support form support@obu.edu www.obu.edu