Hello all.

Yesterday I built a query, which had the source of two other queries.  Built
a report and everything looked fine.

Today, I went into the report and noticed that the grand total of 'errors'
was the total errors multiplied by three.  The total volume was not the total
on the report but the total volume of the entire range.  Again, everything
was fine yesterday (I think?).

When I run the query, it comes back with three results (the same results)
for each User ID.  

Thoughts?  I appreciate your help.  Here is my SQL:

SELECT [Returns Associates].[User ID], [Returns Associates].[Associate
Name], [Individual Associate Error Analysis].[CountOfError Indicator], [Total
Volume By Associate].[SumOfItems], [CountOfError Indicator]/[SumOfItems] AS
Expr1
FROM [Total Volume By Associate] INNER JOIN ([Individual Associate Error
Analysis] INNER JOIN [Returns Associates] ON [Individual Associate Error
Analysis].[User ID]=[Returns Associates].[User ID]) ON [Total Volume By
Associate].[UserID]=[Returns Associates].[User ID]
GROUP BY [Returns Associates].[User ID], [Returns Associates].[Associate
Name], [Individual Associate Error Analysis].[CountOfError Indicator], [Total
Volume By Associate].[SumOfItems], [CountOfError Indicator]/[SumOfItems];