Microsoft KB Archive/79217

= Works Err Msg: Reference Not Valid or Wrong Operand Type =

Article ID: 79217

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a

-



This article was previously published under Q79217



SUMMARY
The Works for Windows error message &quot;Reference not valid or wrong operand type&quot; may be caused when using an OR (|) or an AND (&) operator in a database query if you do not include the name of the field in reference.



MORE INFORMATION
The OR and AND operators in Microsoft Works for Windows can be used to combine multiple criteria for selecting records in a query. If you have a field that contains alphanumeric data, include the name of the field in the query so you can use the OR or AND operators.

A sample for entering a query using an OR condition:

First Name:

Last Name:

State: =State=&quot;NC&quot;|=&quot;WA&quot;

If &quot;=State=&quot; is left out of this query, the error message &quot;Reference not valid or wrong operand type&quot; is generated.

