Works Error: "Reference Not Valid..." or "Invalid Filter" (109134)
The information in this article applies to:
- Microsoft Works 3.0
- Microsoft Works 4.5
- Microsoft Works 4.5a
- Microsoft Works for Windows 95, version 4.0
- Microsoft Works for Windows 95, version 4.0 4.0a
This article was previously published under Q109134 SYMPTOMS
When you use the Query tool in Works, you receive one of the following
error messages.
Works 3.0
Reference not valid or Wrong Operand Type
Works 4.0, 4.5, and 4.5a
Invalid Filter
RESOLUTION
Check for the following conditions:
- The query contains a "reserved" word or character in Works. For
example, the above message displays if you enter the word "month" or
the letter S or N into the Compare To
box and press ENTER.
NOTE: In Works 4.0, 4.5, or 4.5a, the filter allows reserved
words. - You are attempting to query a field that contains a trailing space at
the end of the field name and before the colon (for example, "Last
Name :" instead of "Last Name:").
Querying Methods- To create a query using a reserved word, place double quotation marks
around the reserved word (this is the word in the Compare To
box of the Create New Query tool). For example, to query on
the word month, type month.
- To use the query tool to search a field with a trailing space, choose
Field Name from the Edit menu, to rename the field
without the trailing space.
NOTE: If you want to keep your original field name, you can also switch to the Query View and enter the query formula directly.
MORE INFORMATION
This problem occurs when querying on any words or characters which are
also Works spreadsheet or database functions, such as S, N, SUM, DATE,
MONTH, HOUR and so on.
REFERENCES
For more information about how to perform this task in Works 4.0, 4.5 or
4.5a, see your Works printed documentation or online Help.
"Microsoft Works for Windows User's Guide," version 3.0, page 355
and Appendix A
Modification Type: | Major | Last Reviewed: | 11/15/2004 |
---|
Keywords: | kberrmsg kbprb KB109134 |
---|
|