circular reference

[inungh]

TRANSFORM IIf(IsNull(Sum([correct])/Sum([totalIKB])),0,(Sum([correct])/
(Sum([totalIKB])-IIf(IsNull(Sum([not presented])),0,Sum([not
presented]))))) AS Result
SELECT [SP GET CSR CURRENT IKB RAW].Weekending
FROM [SP GET CSR CURRENT IKB RAW]
GROUP BY [SP GET CSR CURRENT IKB RAW].Weekending
PIVOT [SP GET CSR CURRENT IKB RAW].SplitName

I have above crosstab query called SP GET CSR CURRENT IKB RESULT which
is working.

I got Circular Reference caused by SP GET CSR CURRENT IKB RESULT when
I create a new select query want to select some field from this query.

A little confused is the crosstab query is working and have a select
query only put one field to select. i am not sure where the Circular
Reference come from.

Your help is great appreciated,

 

[John W. Vinson]

I got Circular Reference caused by SP GET CSR CURRENT IKB RESULT when
I create a new select query want to select some field from this query.

Are you perhaps referencing [SP GET CSR CURRENT IKB RESULT] in the query named
[SP GET CSR CURRENT IKB RESULT]? Perhaps you could post the SQL of the new
select query.

 

[inungh]

I got Circular Reference caused by SP GET CSR CURRENT IKB RESULT when
I create a new select query want to select some field from this query.

Are you perhaps referencing [SP GET CSR CURRENT IKB RESULT] in the query named
[SP GET CSR CURRENT IKB RESULT]? Perhaps you could post the SQL of the new
select query.

TRANSFORM Format(IIf(IsNull(Sum([correct])/Sum([totalIKB])),0,(Sum
([correct])/(Sum([totalIKB])-IIf(IsNull(Sum([not presented])),0,Sum
([not presented]))))),"Percent") AS IKB
SELECT [SP GET CSR CURRENT IKB RAW].Weekending, 2 AS ElementID
FROM [SP GET CSR CURRENT IKB RAW]
GROUP BY [SP GET CSR CURRENT IKB RAW].Weekending, 2
PIVOT [SP GET CSR CURRENT IKB RAW].SplitName


Thanks for helping, here is the SQL in the [SP GET CSR CURRENT IKB
RESULT] which does not have [SP GET CSR CURRENT IKB RESULT]

thanks again,

 

[inungh]

I got Circular Reference caused by SP GET CSR CURRENT IKB RESULT when
I create a new select query want to select some field from this query.

Are you perhaps referencing [SP GET CSR CURRENT IKB RESULT] in the query named
[SP GET CSR CURRENT IKB RESULT]? Perhaps you could post the SQL of the new
select query.

It works if I take out sum function in the TRANFORM clause.
Any ideas or suggestions to check does crosstab allow sum function in
the TRANSFORM clause?

The crosstab is working, but I get Circular Reference if I use it in
my select query.


Your help is great appreciated,