The query retrieves too many columns.

• Remove the fields in the query design grid that you don't want to see in the query results, and remove the asterisk (*) if you added it to the design grid. The asterisk automatically includes all fields from the underlying table. For more information on removing fields, click .
  
  
• Hide fields that you don't need to display in the query's results. For more information, click .
  
  
• Verify that the Output All Fields check box isn't selected. (To see if it is selected, on the Tools menu, click Options, and then click the Tables/Queries tab.) If it is, all fields from the underlying table or query will appear in the query's results without being added to the query design grid. If you then add a field to the design grid, say, for setting criteria, you need to clear the Show check box for that field; otherwise, the column appears twice in the query's results. If you want, clear the Output All Fields check box. Changing this option only affects the property setting for new queries you create, not existing queries.