OFF98: Undo Criteria Removes All Criteria Fields and Tables

• Microsoft Query 98 Macintosh Edition
• Microsoft Office 98 Macintosh Edition

SYMPTOMS

When you add criteria to the criteria pane in Microsoft Query and undo your last action by clicking Undo on the Edit menu (or COMMAND+Z), all of the fields in the criteria pane are removed and all of the tables are removed from your query.

CAUSE

This problem occurs when you do all of the following in Microsoft Query:

• You do not have the Automatic Query set to On.


-and-


• You click Undo on the Edit menu.

WORKAROUND

To work around this problem, set the Automatic Query feature to On before you attempt to undo any actions in the criteria pane. To turn on the Automatic Query feature, click the Auto Query button or on the Records menu, click Automatic Query. Note that when this feature is enabled, the Auto Query button will appear pressed and the Automatic Query command on the Records menu will appear with a check mark.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Query 98 Macintosh Edition.

MORE INFORMATION

In Microsoft Query, there are several ways you can retrieve external data. When you want to create a simple query or criteria for creating a more complex query, you can use the Query Wizard. A criteria is a method of filtering the data by specifying values to match records within certain fields. Microsoft Query allows you to view the result set in its data pane. When you are sure the result set contains the data you want, you can return it to Microsoft Excel.

REFERENCES

For more information about adding criteria, click the Office Assistant, type criteria, click Search, and then click to view "Specify what records to retrieve by using criteria."

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:

Q179216 OFF98: How to Use the Microsoft Office Installer Program

Additional query words: XL98

Keywords : kbdta xlquery
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type :