Microsoft KB Archive/145820

= Works: 100-Character Limit In Filter/Query Comparisons =

Article ID: 145820

Article Last Modified on 11/15/2004

-

APPLIES TO


 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a

-



This article was previously published under Q145820



SUMMARY
When you apply a filter in a Works 4.0, 4.5, or 4.5a database, the Compare To box will not accept more than 100 characters. Similarly, when applying a query in Works 3.0, the Value to Compare Field To box will not accept more than 100 characters.

If you attempt to type more than 100 characters into these comparison boxes you will receive a warning sound indicating that you have reached the maximum number of characters for the comparison box.



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.

Additional query words: 3.00 4.00 4.00a 4.50 4.50a w_works filters queries formulas values maximum

Keywords: KB145820

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.