Filter records Using this tool will enable you to use somewhat more advanced operations when processing tables. Once you have defined a condition, the program will find all records that satisfy it. After that, you may select the found records, as well as delete them, or use them to create a new table. You can define an infinite number of filters, and the program will execute them consecutively. In order to start this option, select Database from the View menu. Then click the Filter button from the toolbar. Adding a new filter In order to define a new filter, click the Add button. A window like the one below will open up: The filter is defined by selecting a column from the first combo box i.e. the one wherein the program would be looking for keywords defined by you within the corresponding text box. Include Type Use this option to select only those records that fulfill the given condition. The action (delete, select, new table) would encompass only those records that satisfy this condition. Exclude Type Use this option to select only those records that DO NOT satisfies the given condition. The action (delete, select, new table) would encompass only those records that DO NOT satisfies this condition. Filter out records All records that satisfy the condition would be deleted. Activate the Create backup copy option to avoid an unexpected data loss. Select records All table records that satisfy the condition would be selected. Build a new table The program will create a new table with records that satisfy the condition. Create backup copy of the current table Before it introduces a single change, the program will create a backup copy of your table. The name of the new table will be of the: table name + '_Backup' type. Search criteria The program will select only those column values that fully correspond to the defined keywords. Contains The program selects column values if it contains keywords in any text section. Starts with The program will select values if they start with defined keywords. Ends with The program will select values if they end with defined keywords. Before Date The program will search for dates before the one you will define. After Date The program will search for dates after the one you will define. Between Date You should define two dates and the program will search for all dates between the two. Delete Table, Rename Table, Properties Searching tables for records Printing Edit Table Columns See Also: Database Wizards E-mail Merge Extracting data from the web forms