Using filters is the query designer:

• Select the table and then the column you would like to use in you Sql statement.
• Select a "WHERE" or a "HAVING" clause
• Click the "Add" button to add the column to the statement.
• Double click the filter to add it to the statement

Filter can also be used in a "Select Box" query. However, the query used must have a higher sort order than that of the query that is being designed.