circular reference cause by query

[mike02]

Hello,

I have a query that runs just fine. but when i make a report of the query it will not run. It says "Circular Refrence caused by 'query'



here is the sql of the query.

TRANSFORM First(qryHypotheticalReturns.YTD) AS FirstOfYTD
SELECT tblProducts.ProductName
FROM qryHypotheticalReturns INNER JOIN tblProducts ON qryHypotheticalReturns.ProductID = tblProducts.ProductID
WHERE (((tblProducts.ProductID)=4 Or (tblProducts.ProductID)=6))
GROUP BY tblProducts.ProductName, tblProducts.ProductID
ORDER BY tblProducts.ProductID
PIVOT qryHypotheticalReturns.Year;

the query runs on its own, but it will not run in my report. anyone deal with this issue before?

thanks,

[offie]

I get that error when I name something the same as one of the things I'm using to calculate it: ex: count(Name1) As Name1. So my guess is that you did a calculation or code somewhere where you named it the same thing? I don't see that in the query SQL so it would probably be in the report?

[mike02]

I have had that before. I dont think its the issue here.

It origionally worked, but once i made a form to have a parameter on the queries with the report. i have a Between date criteria:

Between #31/01/2005# And forms!frmReportCenter!cboDate

[offie]

Huh, werid. Are the selections for the combo formatted to be dates? Have you made sure that the query/record sources in the report are up to date? How are the dates set up on your computer/Access (have you had an issue with dates before)?
That's all I got, Good luck!

[mike02]

solved it. I had a cross tab query that i got data from for my setup query for this cross tab. I didnt define the column headings.