Advanced Filter Criteria

Advanced Filter  functions identically to Excel's Advanced Filter feature with the copy to another location option (the report is the other location).  It does NOT filter the data set in place.  Records that do not meet the filter criteria will not be in the report. 

This following data set will be used to show how the criteria changes the reports output.

EXAMPLE

Filter Description	Criteria	Results
Return all records where First Name = Jane	ID First Name Last Name Order Jane	ID First Name Last Name Order 1 Jane Doe Milk 1 Jane Doe Butter
Return all records where the Order field is blank	ID First Name Last Name Order ="=" Note: only the equal sign, =  will be visible	ID First Name Last Name Order 3 Eleni Smith
Return all records where the Order field is not blank	ID First Name Last Name Order ="<>" Note: only the less than/greater than signs, <>  will be visible	ID First Name Last Name Order 1 Jane Doe Milk 2 John Doe Eggs 1 Jane Doe Butter
Return all records where First Name begins with the letter J OR the Order field has the letter e in it	ID First Name Last Name Order j* *e*	ID First Name Last Name Order 1 Jane Doe Milk 2 John Doe Eggs 1 Jane Doe Butter
Return all records where First Name begins with the letter J AND the Order field has the letter e in it	ID First Name Last Name Order j* *e*	ID First Name Last Name Order 2 John Doe Eggs 1 Jane Doe Butter

See also