The query retrieves too few columns.

• Add more fields to the query design grid. Or if you add the asterisk to the design grid, the query automatically includes all fields from the underlying table or query. For more information, click .
  
  
• Add other tables or queries, then add the other fields you need. For more information, click .
  
  
• Show hidden fields. For more information, click .
  
  
• If the Output All Fields check box is not selected, only the fields in the design grid are retrieved. (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. Or 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.