Works: 100-Character Limit In Filter/Query Comparisons

MORE INFORMATION

To create a filter with more than 100 characters, use the Filter Using Formula, in Works 4.0, 4.5, or 4.5a. The Filter Using Formula dialog box has a 255 character limit.

In Works 3.0, you can perform a query with more than 100 characters by using the Query View option. You can enter a maximum of 255 characters on a field line. Additional parameters may be placed next to a different field name in Query view. In that case, only records matching all criteria in all fields in Query view will be displayed.

For example, if you have a database that contains the fields, First Name, Age, Sex, and State.

Enter the following into Query View:

   Field1:=(Sex="M"#AND#State="WA")#OR#First name="John"

   Field2:=(Age>=27)
				

For a record to display after the query is run, the record must meet the criteria for Field1 and the criteria for Field2. The query will find records where Sex equals M, and State equals WA, or First name equals John and Age is equal to or greater than 27.