Results multiplied by 3??

[Love Buzz]

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];

 

[Jeff Boyce]

I'll guess that your underlying data has a one-to-many relationship
somewhere in there.

It all starts with the data. Consider posting a description of your
underlying data for more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Love Buzz]

Thanks for responding Jeff. I found the problem. I had three tables joined
and I only needed two of them. All is good

I'll guess that your underlying data has a one-to-many relationship
somewhere in there.

It all starts with the data. Consider posting a description of your
underlying data for more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

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];