The information in this article applies to:
SYMPTOMSThe Query Wizard may not appear when you edit an existing query. Instead, the query appears in Microsoft Query. CAUSEThis problem occurs if the query does not use a certain format even if you originally created the query by using the Query Wizard. When you edit an existing query, the Query Wizard is designed to display queries that use either of the following two formats: (test = a) OR (test = b) OR (test = c)The expression must be a series of clauses that are in a single column connected by the OR operator, or a series of clauses that are in multiple columns connected the AND operator. That is, the expression must be represented in the Criteria pane as a single row or single column. RESOLUTIONIf the query does not meet either of the formats in the "Cause" section, you cannot edit the query by using the Query Wizard. You must modify the query in the Criteria pane in Microsoft Query. STATUSThis behavior is by design of the Query Wizard. MORE INFORMATION
In Microsoft Query, there are several options for retrieving external
data. To take advantage of these options and ensure that you get the
results you're looking for, keep the following guidelines in mind:
REFERENCES
For more information about the Query Wizard, click the Office Assistant,
type query wizard click Search, and then click to view "Guidelines for
constructing a query."
Q120802 Office: How to Add/Remove a Single Office Program or Component Additional query words: XL97
Keywords : kbtool xlwiz xlquery |
Last Reviewed: October 12, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |