4TOPS Filter Builder is an
add-in for filtering data in your Microsoft Access database.
It also is included in the 4TOPS Data Analysis.. Use it
to select records according to the desired criteria. You
don't have to learn the SQL-syntax. Filtering is faster
and simpler: Filters on forms, subforms (New), datasheets
and reports Depending on field type a list of applicable
filter templates is shown.
Selecting the ones related
to your query adds the corresponding SQL code in the edit
box. Many templates are available for date-related filters.
Parameter values are asked using special dialogue boxes.
In the case of text fields, you can select existing values
from a list box to specify 'IN' or 'NOT IN'
|