"Query must have at least one destination field" error when you run an Access query

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

Symptoms
When you run an existing Microsoft Access query, you receive the following error message:

Query must have at least one destination field.

You do not see the expected query in Design View, and you see only Select; or Select *; in SQL View.
Cause
This problem occurs when you run the OutputTo method because of an issue that affects reading the structure of queries that have been designed and saved only within SQL View.
Workaround
To work around this problem, use one of the following methods:

  • For each database that is affected by this problem, open the database in Access, click Options on the File menu, select Current Database, and then clear the Track name AutoCorrect info check box.
  • Make sure that each query is opened and saved while in you are in Design View.
Status
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
Query deleted missing sql view form report macro VBA
Properties

Article ID: 3189523 - Last Review: 09/09/2016 22:02:00 - Revision: 1.0

Access 2016, Microsoft Access 2013, Microsoft Access 2010, Microsoft Office Access 2003, Microsoft Office Access 2007

  • KB3189523
Feedback