Report From Query Problem

[SgtJarrow]

I have a report based on a query. Wehn I open the query everything is fine. But when I try to open the report, I get the following error....

The specified field 'qryGBP.Rate' could refer to more than one table listed in the FROM clause of your SQL statement.

If I remove the textbox that is bound to qryGBP.Rate, report opens fine. But the moment I put it back....it doesn't work. As I said before I can open the query perfectly fine.

Here's the SQL behind the query....

SELECT tblREAccountInfo.AccountName, tblREAccountInfo.InvoiceBase, tblREAccountInfo.CurrencyCode, tblRESummary.Value, qryAUD.Rate, qryCAD.Rate, qryHKD.Rate, qryJPY.Rate, qryMYR.Rate, qryTWD.Rate, qryUSD.Rate, qrySGD.Rate, qryGBP.Rate
FROM qryAUD, qryCAD, qryHKD, qryJPY, qryMYR, qryTWD, qryUSD, qrySGD, qryGBP, tblREAccountInfo INNER JOIN tblRESummary ON tblREAccountInfo.SafekeepingNumber = tblRESummary.SafekeepingAccount
ORDER BY tblREAccountInfo.InvoiceBase;


I am stumped....anyone???? Thanks. Programming isn't a profession of choice.
It's a profession of calling...
"Hey Programmer, your application broke again!"

Robert L. Johnson III, A+, Network+, MCP
robert.l.johnson.iii@ssmb.com