The query retrieves the wrong records.

• Verify that existing criteria is entered correctly. Check for misspellings, unnecessary spaces, or extra characters. Verify that you set the criteria for the appropriate field and that it's the criteria you want the records to meet.
  
  
• Verify that the tables and queries you've added to the upper part of query Design view are the correct ones. For information on adding a table or query, click . For information on deleting a table or query, click .