Current Filter Settings:


	
Enter Filter Data

	
If the filter entry is cleared then filtering will not take place. To 
	turn filtering off then "Clear Form" and "Submit".

	
If Filter has filtering information and Submitted then filtering will 
	take place when Database is displayed.


    


        Filter

        





        


        


        
    	


    



    
RULES and EXAMPLES:

    State="KY" (This will display all records where the state is Kentucky)

    Name="Grace*" (This will display all records where name begins with Grace. The * is a wild card character.)

    You can use the AND or OR with filter command. Such as Field1="Data1" AND Field2="Data2"

    For Example:

    ZIP>"41000" AND ZIP<"60000"

    NAME="Grace*" AND STATE="KY" (Will display all churches that begin with Grace and in the State of Kentucky.)

    NAME="*Sovereign*" (Will display records with Sovereign somewhere in the church name.)



    MISSION="RO" (Code for Romania only.)

    MISSION="TH" (Code for Thailand Only.)

    MISSION="RT" (Code for Romania and Thailand)

    So to display all churches for Romania the Filter would need to be as follows:

    MISSION="RM" OR MISSION="RT" (Include OR in command so that it displays both of those codes.

    So likewise for Thailand it would be similar.

    MISSION="TH" OR MISSION="RT" (That way it catches all churches that support Thailand, but may also support Romania
 
 

    RECNUM<100 (will display all records less that record 100)

    Filter on the Notes field does not work since it is a Memo field.

    
Field Names:

    NAME

    ADDRESS

    CITY

    STATE

    ZIP

    MISSION

    NOTES (Does not work with filtering because it's a TDbf.TMemo type field)

    STAMP (Format = yyyy-mm-dd@hh:mm:ss)

    RECNUM (Physical Record Number in Data Base)