Chart error

[marta]

Hello,
I have generated a query that summarizes for me data I
need to chart. My issue is that when I go to view the
chart I have just created the following message pops up:

"The specified field'[SWAP - Sector 1Week Change].
[SwapSector.SwapSector]' could refer to more than one
table listed in the FROM clause of your SQL statement."

This is my SQL statement:

SELECT [SWAP - Sector 1Week Change].
[SwapSector.SwapSector] AS Expr2, Avg([SWAP - 1 Week
Change Test].Expr1) AS AvgOfExpr1
FROM [SWAP - 1 Week Change Test]
GROUP BY [SWAP - Sector 1Week Change].
[SwapSector.SwapSector];

I have gone about creating this query in different ways
and I still get error messages. Might you be able to help
me identify the problem here?

Thanks so much!
marta