The results of a totals (aggregate) calculation in the query are wrong.

• If there are records with Null (blank) values in the field you are calculating, those records won't be included in the calculation. For more information on Null values, including how to include them in a calculation, click .
  
  
• If the query isn't performing the calculation on the correct groups, verify that you have Group By in the Total cell for the field or fields you want to use for grouping calculations. For information on performing calculations on groups of records, click .
  
  
• In a crosstab query, you might have too many or too few Group By fields. Add, remove, or change the fields designated as row headings that group the totals vertically. Verify that you're using the correct field's values as column headings that group the totals horizontally.
  
  
• Where you specify criteria in the query design grid determines if records are excluded before the query groups or performs calculations, if groups are excluded before the calculation is performed, or if certain results are excluded after the calculation is performed. For more information, click .
  
  
• Verify that the aggregate you selected is the correct one. If not, select a different aggregate from the list in the Total cell. For more information on different aggregate functions, click .