Where Button

The Where button is used to add filters to the data. You can hard code values or add parameters to filter the data when downloading.

Field	Description
Search Columns	Use this to filter the list of Available Columns.
Available Columns	This lists all columns that can be filtered based on the main table and joined tables selected.
Selected Column	This is the column that will be filtered.
Value 1	This can be a hard coded value or you can use the @PARAM button to create a parameter.
Value 2	This appears when you use the Between and Not Between operators.
And	Use this if the filter should be true in addition to what already exists.
Or	Use this if the filter could be true or what already exists is true. This is not used a lot.
Allow Blank Parameter Values	Use this when adding a parameter if you do not want the parameter to be required.
New Parameter	Enter a new parameter name here and make sure to select a column. This is only needed if the parameter is only used on the Select or Join buttons.
Parameters	This lists all parameters currently in the report.
Where Clause	This shows the current filters. You can add manual changes to the box if needed.

Button	Description
	This will clear the search box.
	Equal To
	Not Equal To
	Greater Than or Equal To
	Greater Than
	Less Than
	Less Than or Equal To
	This adds a parameter to the Value fields and cycles through existing parameters.
	Use to search for a specific pattern. If a match is found then the record will be included.
	Use to search for a specific pattern. If a match is found then the record will not be included.
	Allows you to specify multiple values that you separate with a comma.
	Allows you to specify multiple values that you separate with a comma.
	Use for values within a given range.
	Use for values not within a given range.
	Use to find fields with no value.
	Use to find fields with a value.
(Parameter)	This will add the new parameter if a column is selected and a parameter named is entered.
(Parameter)	This will show in place of Add if you select a parameter from Parameters to edit. Use this to save any changes.
(Parameter)	This will clear the Selected Column and New Parameter fields.
(Parameter)	This will delete any selected parameters. If you delete parameters make sure the appropriate lines in the Where Clause are removed.
(Column)	This will add the new filter after all required values have been selected.
(Column)	This will clear all fields on the form.
	This will save any changes to the Where portion of the SQL Statement.
	This will cancel any changes to the Where portion of the SQL Statement.

Feedback