You can filter the data that appears on a data sheet by using conditions. Only the data that meets the specified conditions display in the data sheet at run time. You can set up custom filters from the Insert Data Sheet window when you create the data sheet or from the Data Sheet Properties window after the data sheet is set up. To access the Data Sheet Properties window, you can right-click the data sheet field, and select Properties.
 
 
  - In the General tab of the Insert Data Sheet or Data Sheet Properties window, select the Filter tab to open it. 
   
 
  - In the Custom Data Filter window, enter the condition directly, or select it through one of the following: 
   
   
    Your selections are added to the Custom Data Filter window.
   
 
  - To go to another tab, select the tab. 
   
    - If you have completed filling in tabs, to save the data sheet information, select OK.
 
   
 
  - Save the template.